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.

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

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.

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

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.

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

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.

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

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

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

So the lines you choose will be hidden.

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

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).

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

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

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

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

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

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 .

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

2. Show hidden columns in Excel

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

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

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!