top of page

Microsoft Excel
Use Grouping to Quickly
Show/Hide Multiple Excel Columns

Excel Icon.png
Back Button

Do you often hide/show the same columns in a file? Instead of constantly re-selecting the columns and choosing Hide/Unhide, why not using grouping, which is faster and more efficient? Here's how:

1. Apply grouping by selecting the consecutive columns > Data tab > Group button

2. Click the - sign to collapse or + sign to expand individual groups

3. To expand or collapse all groups, click the numbered boxes on the far left

4. To remove grouping, select the column(s) and click Ungroup

Note: Rows can also be grouped

Grouping 1.jpg

© 2017 DJH Training & Application Solutions Inc.

bottom of page