Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 2 spreadsheets that I'm auditting line by line and need to re-sort
them now and again in sections for different views. I currently have certain columns hidden to view them side by side and make printing easier. My question is when I sort certain ranges, will it automatically include the hidden columns that fall within the range of my sort or will they be ignored since they're hidden? Example: A, C, E, F are hidden. My sort includes B - M. Will the columns C, E, F that are hidden be sorted with the rest? I know A will not unless I unhide it, which I can live with; it's the middle information I need to keep together. Thanks for the info. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect hidden rows/columns -macro help | Excel Discussion (Misc queries) | |||
How do I auto expand hidden rows or columns? | Excel Discussion (Misc queries) | |||
Is there a way to exclude hidden rows/columns when printing a doc | Setting up and Configuration of Excel | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
hidden rows/columns | Excel Discussion (Misc queries) |