Macro To Group Columns In Excel Worksheet

Previously we wrote a macro to group multiple columns in multiple worksheets in an excel workbook. Below macro is to group columns in the active worksheet.

 

Macro To Collapse Grouped Columns In Multiple Worksheets

If you have grouped multiple columns in more than one worksheet, you can use below macro to collapse all the grouped column in all the worksheets in one go.

 

Macro To Expand All Grouped Columns In Multiple Worksheets

If you have grouped multiple columns in more than one worksheet, you can use below macro to expand all the grouped column in all the worksheets in one go.