Ask Experts Questions for FREE Help !
Ask
    madmax88's Avatar
    madmax88 Posts: 2, Reputation: 1
    New Member
     
    #1

    Mar 24, 2008, 01:18 PM
    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?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Mar 24, 2008, 06:00 PM
    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.
    madmax88's Avatar
    madmax88 Posts: 2, Reputation: 1
    New Member
     
    #3

    Mar 25, 2008, 04:44 AM
    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.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Financial statements and using excel to input data [ 1 Answers ]

It is so difficult to input data in excel ( not hard coded numbers but linking numbers) Can anyone explain how to do that If I have the given information on the first sheet of excel i.e the data entry sheet. How can I enter data on other sheets for different statements like trial balance,...

Excel 07 - Pressing enter won't bring me to the A column [ 4 Answers ]

I'm new to excel and learning it at my local college but am stuck with a small problem. say I enter info in A2, then B2... and so on until I get to say... E2. If I hit enter after inputting info into E2 my next active cell is random. its going between all the letters in the next row down,...

Shortcut for entering data in Excel [ 2 Answers ]

I often work with data in scientific notation. Is there a shortcut for entering numbers using only the number section of the keyboard? (i.e. entering 1.7E+09 without using the ‘e’ character)

Column Protect in excel [ 1 Answers ]

How to protect the column in excel??

Excluding data from column [ 5 Answers ]

hi. Excel question. I have a number of column's, but I am mainly concerned with 2 columns, and the generation of new column. One column is a series of data where values equal, 0, 1000, -1000, 2000, -2000, and 1,2,3... 9. the other column has modulus values corresponding to this data (0, 1000,...


View more questions Search