Hide and display columns and rows in Excel

In the process of working with excel, you want to hide a certain row or column because of job requirements. The following article details how to display or hide columns and rows in excel.

1. Hide columns

For example, to hide the Layer column:

Hide and display columns and rows in Excel Picture 1

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

Hide and display columns and rows in Excel Picture 2

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

Hide and display columns and rows in Excel Picture 3

2. Show columns

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

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

Hide and display columns and rows in Excel Picture 4

The Layer column is shown with darker lines.

Hide and display columns and rows in Excel Picture 5

3. How to hide rows

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

Hide and display columns and rows in Excel Picture 6

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

Hide and display columns and rows in Excel Picture 7

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

Hide and display columns and rows in Excel Picture 8

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 :

Hide and display columns and rows in Excel Picture 9

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

Above is how to display and hide rows and columns hope you apply them often.

Good luck!