Hide Columns or Rows

 

Hide | Unhide | Multiple Columns or Rows | Hidden Tricks

Sometimes it can be useful to hide columns or rows in Excel.

Hide

To hide a column, execute the following steps.

1. Select a column.

Hide Column Example

2. Right click, and then click Hide.

Click Hide

Result:

Hidden Column in Excel

Note: to hide a row, select a row, right click, and then click Hide.

Unhide

To unhide a column, execute the following steps.

1. Select the columns on either side of the hidden column.

Unhide Column Example

2. Right click, and then click Unhide.

Click Unhide

Result:

No Hidden Columns

Note: to unhide a row, select the rows on either side of the hidden row, right click, and then click Unhide.

Multiple Columns or Rows

To hide multiple columns, execute the following steps.

1. Select multiple columns by clicking and dragging over the column headers.

Select Multiple Columns

2. To select non-adjacent columns, hold CTRL while clicking the column headers.

Select Non-adjacent Columns

3. Right click, and then click Hide.

Click Hide

Result:

Hidden Columns in Excel

To unhide all columns, execute the following steps.

4. Select all columns by clicking the Select All button.

Select All Columns

5. Right click a column header, and then click Unhide.

Click Unhide

Result:

Unhide All Columns

Note: in a similar way, you can hide and unhide multiple rows.

Hidden Tricks

Impress your boss with the following hidden 🙂 tricks. To hide and show columns with the click of a button, execute the following steps.

1. Select one or more columns.

Select One or More Columns

2. On the Data tab, in the Outline group, click Group.

Click Group

3. To hide the columns, click the minus sign.

Hide Columns

4. To show the columns again, click the plus sign.

Show Columns

Note: to ungroup the columns, first, select the columns. Next, on the Data tab, in the Outline group, click Ungroup.

Finally, to hide cells in Excel, execute the following steps.

1. Select a range of cells.

Select Cells

2. Right click, and then click Format Cells.

The ‘Format Cells’ dialog box appears.

3. Select Custom.

4. Type the following number format code: ;;;

5. Click OK.

Type the Number Format Code

Result:

Hidden Cells

Note: the data is still there. Try it yourself. Download the Excel file, hide cells, select one of the hidden cells and look at the formula bar.

Previous articleHow to use GETPIVOTDATA in Excel
Next articleHow to Lock Cells in Excel