Group / hide multiple seperate columns

[nparsons75]

Hi, I need to group multiple seperate columns. The issue is excel will not let me group seperate columns using the standard group feature. Is anyone aware of any kind of workaround to allow me to emulate this. Normally I would be able to press the + sign to expand and - to retract, I need to be able to do this but with the seperate columns. Hopefully their is a way... thanks in advance

 

[Peter_SSs]

Is anyone aware of any kind of workaround to allow me to emulate this.

You could have a macro similar to this (possibly activated from a button on the worksheet)

Sub ToggleColumns()
  With Range("K:M,P:P,S:T").EntireColumn
    .Hidden = Not .Hidden
  End With
End Sub