Excel with hidden lines - How to hide lines and display hidden lines in Excel

Sometimes in the process of working, processing data in Excel, you need to hide / show the line in Excel. If you do not know how to hide lines and display hidden lines in Excel, please refer to the following article.

Here's how to hide rows, show hidden lines in Excel, and how to hide / show columns in Excel invite you to follow.

How to hide lines in Excel

Step 1: Select the line to hide.

If you only need to hide one line, then click on the number before that line.

If you want to hide multiple rows in a row, then you select the first line to be hidden, then you hold down the mouse and drag down the other lines to be hidden.

If you want to hide multiple lines separated (non-consecutive), then you select the first line to be hidden, then hold down Ctrl and select the other lines to be hidden.

Step 2: Right-click on the lines you have selected and select Hide to hide the lines.

So the lines you choose will be hidden.

How to display hidden lines in Excel

Step 1: Select (black out) consecutive lines of hidden lines (lines above and lines below the hidden lines).

Step 2 : Right-click on the selected lines and choose Unhide to show hidden lines.

Or if you want to display a hidden line, right-click on the hidden location and select Unhide .

Similarly, you can hide the column and display the hidden column as follows:

1. Hide columns in Excel

Select the columns to hide, then right-click the selected columns and choose Hide .

2. Show hidden columns in Excel

Select adjacent columns (the previous column and the column after the hidden columns), right click and select Unhide .

Above the article has shared with you how to hide lines and display hidden lines in Excel, hope the article will help you. Good luck!