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?

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.

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.