How to collapse columns in excel
By
SpreadCheaters
Page last updated:
18/11/2022 |
Next review date:
18/11/2024
You can watch a video tutorial here.
Collapsing columns are very important to clean up the spreadsheet and show the most essential parts.
Step 1 – Select the columns you want to group
Select the columns you want to group
Step 2 – Under the Data tab, click on Group
Clicking the Group button will show a line on top of the highlighted columns. Another option to group up the columns is to use
SHIFT + ALT + RIGHT ARROW KEY simultaneously.
Step 3 – Click the “-” button at the top of the columns.
Clicking the “-” will automatically hide the columns. In this case, columns D and E will be hidden
