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

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