Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How can I sort data on a Hidden column in Excel? (https://www.askmehelpdesk.com/showthread.php?t=198118)

  • Mar 24, 2008, 01:18 PM
    madmax88
    How can I sort data on a Hidden column in Excel?
    I have a spreadsheet that has a pivot table in it.

    Each record has a time group column and a time nbr column in the pivot table.
    (i.e. Timegroup = 90 days before and a timenbr of 1 is assigned to this group,
    Timegroup = 60 days before and a timenbr of 2 is assigned to this group,
    Timegroup = 90 days before and a timenbr of 1 is assigned to this group.
    )
    Sorting by the timenbr will put the timegroups in the order that I want in the pivot table.
    I don't however want the timenbr column to be displayed. I want to hide that column.
    Problem is where this column falls in the spreadsheet. It falls in column B which is also the same column that my page fields fall in the top lefthand corner of my pivot table. If I hide timenbr, I also hide those page field selections.

    Looks something like this...

    column A Column B

    Zone Great Plains <<<< choose which zone you want here...
    West

    Pivot table at bottom looks like this...

    State Timenbr Timegroup
    AZ 1 90 Days before
    AZ 2 60 days before
    AZ 3 30 days before

    If I hide timenbr, I end up hiding the page field selections above in column B... how can I still sort my data by timenbr, and not display the information in the timenbr column?
  • Mar 24, 2008, 06:00 PM
    JBeaucaire
    Is this because you don't want the information to PRINT, or don't want it visible at all?

    Highlight all the cells in question, set the font color to white. Voilą... they're invisible onscreen and when printed, but putting your cursor on the cell still shows the entry in the formula bar.
  • Mar 25, 2008, 04:44 AM
    madmax88
    Quote:

    Originally Posted by JBeaucaire
    Is this because you don't want the information to PRINT, or don't want it visible at all?

    Highlight all the cells in question, set the font color to white. Voila...they're invisible onscreen and when printed, but putting your cursor on the cell still shows the entry in the formula bar.


    Thank you so much for your response... but it didn't work. If I make the font white and take out the border lines (created by the pivot table), I'm still left with the selection row
    That I can't get rid of and it looks kind of funky.

    I appreciate you trying to help me.. I think I just decided that I will incorporate a little more text into the timegroup and sort that way... I put in Group 1 - 0-30 days, Group 2 - 0-60 days, etc... and just sorted by the timegroup.

    Thank you so much though for trying to help me with my problem. I really do appreciate it.

  • All times are GMT -7. The time now is 07:10 AM.