Skip to content

How to hide and unhide rows in Excel?

  • by
  • 4 min read

Excel is an incredibly versatile tool that is used by millions of people around the world. Whether you are a student, a professional, or just someone who likes to keep track of their finances, Excel has a wide range of features that can help you get things done more efficiently. One of these features is the ability to hide and unhide rows in a spreadsheet. This can be incredibly useful if you are working with a large amount of data and you want to focus on a specific section.

In this article, we have discussed how to hide and unhide single and multiple rows in a few simple and easy steps.

Also read: How to hide and unhide columns in Excel?


How to hide and unhide a single row?

Hiding a single row

Below we have explained the steps to hide a single row in Excel.

Step 1: Open the Excel document in which you want to hide the row and then right-click on the row number.

Step 2: In the dropdown menu, click on the Hide option. A double line will be created between the adjacent row numbers.


Unhiding a single row

Below we have explained the steps to unhide a single row in Excel.

Step 1: Select the rows adjacent to the hidden row and right-click on the row number.

Step 2: In the drop-down menu, click on the Unhide option.


Alternative to unhiding a single row

Below explained the step for an alternate method to unhide a single row in Excel.

Step: Double-click on the double line between the adjacent rows of the hidden row that appeared after hiding the row.


How to hide and unhide multiple rows?

Hiding multiple rows

Below we have explained the steps to hide multiple rows in Excel.

Step 1: Select the rows by clicking and dragging over the row numbers that you want to hide. To select the non-adjacent rows Press the Ctrl key on your keyboard and click on the non-adjacent rows that you want to hide with other rows.

After selecting the rows right-click on any row number.

Step 2: In the dropdown menu, click on the Hide option.


Unhiding multiple rows

Below we have explained the steps to unhide multiple rows in Excel.

Step 1: Select all the rows by pressing the Ctrl+A key and then right-click on any row number.

Step 2: In the drop-down menu, click on the Unhide option.

Also read: How to move a row in Excel?

Akash Singh

Akash is a law graduate who likes to go for bike rides on the weekends soul-searching for answers to his many existential questions. You can contact him here: singhakash95@pm.me

>
Exit mobile version