View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Markos Hunter Markos Hunter is offline
external usenet poster
 
Posts: 1
Default Pivot Table Grouping

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