Content

• Steps

In this article, we will show you how to hide multiple columns in a Microsoft Excel spreadsheet using the Group function.

Steps

1. 1 Open the spreadsheet in Microsoft Excel. Double-click the Excel file on a Windows or Mac OS X computer.
2. 2 Select the columns to be hidden. To do this, click on the letter above the first desired column, and then drag the mouse pointer to select the second column. Both columns will be highlighted.
   • If you want to hide multiple cells rather than entire columns, select those cells (instead of selecting the column letters).
3. 3 Go to the tab Data. It's at the top of the window.
4. 4 Click on Group. You will find this option in the upper right corner of the screen under the "Structure" group.
5. 5 Please select Columns in the Grouping pop-up window, and then click OK. If the Grouping window does not open, go to the next step.
6. 6 Click on -to hide the columns. It's on the left side of the gray bar above the table. The columns will be hidden, and the "-" icon will become "+".
7. 7 Click on +to display the columns.