Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple column filtering
Hi,
I am trying to group multiple non-consecutive columns so that all columns can be hidden and each group can be displayed. I have 40 columns with multiple rows on a worksheet and want to set up vertical groupings i.e. group columns (A, D, G, J ....) together, and then (B, E, H, K... together), and so on - final result is that all columns can be hidden and each 'group' can be displayed on its own. I know that rows can be grouped together using the 'Group' function but am not sure of columns. Does anyone know if this can be done on Excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Column Auto Filtering | Excel Discussion (Misc queries) | |||
Filtering for Unique Records with multiple-column criteria | Excel Discussion (Misc queries) | |||
multiple worksheet filtering | Excel Discussion (Misc queries) | |||
Filtering Multiple Instances | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |