| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I group and display columns automatically?
I have 40 columns on a worksheet and many rows, 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 | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| How do i automatically group rows in a pivot table? | Excel Discussion (Misc queries) | |||
| out of a group of cells, if max, then display this other cell | Excel Worksheet Functions | |||
| How do I get Excel to automatically group items? | Excel Discussion (Misc queries) | |||
| How can I sort a group of numbers automatically as data is entere | Excel Worksheet Functions | |||
Threaded Mode
