View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
faraz316 faraz316 is offline
external usenet poster
 
Posts: 2
Default 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?