Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm quite used to working with pivot tables but not good at creating them so
please go easy! I have36 columns of monthly data displayed jan06, feb06 etc and I would like to group them into years so I can expand/collapse them as required (BY YEAR) At the moment I have to select/deselect each column. It would be easier to select the relevant year and deselect as requireD How do I do this? Please help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grouping with a pivot table | Excel Worksheet Functions | |||
Pivot table grouping | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table or Grouping Help | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Worksheet Functions |