Group Columns Instead of Hiding Them
October 02, 2023 - by Bill Jelen
![Group Columns Instead of Hiding Them Group Columns Instead of Hiding Them](/img/excel-tips/2023/10/group-columns-instead-of-hiding-them.jpg)
Problem: I have a report with months and quarters. My manager sometimes wants the reports printed with months hidden and other times with the months showing. It is a pain to hide/unhide the four groups of monthly columns.
Strategy: You can group the columns instead of hiding and unhiding them. Follow these steps:
1. Unhide all the columns.
2. Select the headings Jan, Feb, and Mar. Select Data, Group, Columns. Excel adds a group and outline symbol above the column headings.
-
3. Repeat step 2 for Apr, May, Jun; Jul, Aug, Sep; and Oct, Nov, Dec.
Excel will draw in Group & Outline buttons above the spreadsheet.
![Manual group and outlines have been set up. Jan, Feb, Mar in B:D will collapse into Q1 in column E and so on.](/img/content/2023/10/LE10001239.jpg)
You can click the 1 Group & Outline button to collapse to quarters. Click the 2 to show months.
![Click the Number 1 Group and Outline button to hide all the monthly data and only show quarters.](/img/content/2023/10/LE10001240.jpg)
This article is an excerpt from Power Excel With MrExcel
Title photo by Kier in Sight Archives on Unsplash