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:

Step 1: Select the column you want 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 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 :

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.

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

Good luck!