Hide and Display Columns and Rows in Excel

This updated guide explains how to Hide and Display Columns and Rows in Excel through clear steps, practical examples, and important checks that help prevent common errors.

1. Hide Columns

For example, to hide the Layer column:

Step 1: Select the column you may need to hide -> Right-click and select Hide .

After selecting Hide the selected column has been hidden and replaced with vertical lines darker than the other lines.

2. Show Columns

In the above example, the Layer column has been hidden. Now you may need to display the Layer column as follows:

Step 1: Select the left and right columns of the hidden column -> Right-click and choose Unhide :

The Layer column is shown with darker lines.

3. How to Hide Rows

For example, want to hide the row in the 2nd order:

Step 1: Select the rows to hide -> Right-click and choose Hide :

The row has been hidden and replaced with a line that is bolder than the other lines.

4. Show Hidden Rows

In the above example, I have hidden the row in the 2nd order, the following will display the second row again.

Step 1: Select rows above and below rows that have been hidden -> Right-click and choose Unhide :

The hidden row is displayed and is replaced with a bold line other lines.