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?