How to hide columns in Excel: 7 steps (with pictures)

How to hide columns in Excel: 7 steps (with pictures)
How to hide columns in Excel: 7 steps (with pictures)
Anonim

If you want to hide multiple columns on a Microsoft Excel spreadsheet, you can use the tool Group.

Steps

Collapse Columns in Excel Step 1

Step 1. Open your Microsoft Excel spreadsheet

On a PC or Mac, you just have to double-click on the file.

Collapse Columns in Excel Step 2

Step 2. Select the columns you want to hide

To do this, click on the letter above the column, and then drag the mouse to include the second column. Both columns should now be highlighted.

If you don't want to hide entire columns, just select the cells you want to hide (instead of the letters at the top of the columns)

Collapse Columns in Excel Step 3

Step 3. Click the Data tab

It is at the very top.

Collapse Columns in Excel Step 4

Step 4. Choose Group

This option is located near the upper right corner of the screen in the menu Plan.

Collapse Columns in Excel Step 5

Step 5. Select Columns in the Group menu and click OK.

If the popup menu Group does not appear, go to the next step.

Collapse Columns in Excel Step 6

Step 6. Click - to hide the columns

This option is to the left of the gray square above your worksheet. The columns will disappear and - will turn into +.

Popular by topic