How to Unhide Multiple Rows in Excel (9 Methods)

If you are looking for some special tricks to unhide multiple rows in Excel, you’ve come to the right place. In Microsoft Excel, there are numerous ways to unhide multiple rows. In this article, we’ll discuss nine methods to unhide multiple rows. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


9 Methods to Unhide Multiple Rows in Excel

We will use nine effective and tricky methods to unhide multiple rows in Excel in the following section. This section provides extensive details on nine methods. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.


1. Unhide Multiple Rows Using Format Command

Here, we have a dataset where rows 6 and 11 are hidden. Our main goal is to unhide the rows. Using the Format command is the fastest way to unhide multiple rows. You have to follow the following rules.

Unhide Multiple Rows Using Format Command

📌 Steps:

  • Firstly, to select all rows from the worksheet, click the Select All Button.

Unhide Multiple Rows Using Format Command

  • Go to the Home tab, and select Format. Then select Hide & Unhide from the menu and finally select Unhide Rows.

  • Finally, you will be able to unhide the rows like the following.

Unhide Multiple Rows Using Format Command

Read More: Hidden Rows in Excel: How to Unhide or Delete Them?


2. Using Context Menu in Excel

You can easily detect hidden rows on a worksheet. To locate them, look for double lines in the row headings. Let’s walk through the steps to find out how to reveal multiple rows in Excel.

Using Context Menu in Excel

📌 Steps:

  • Firstly, select the rows that you want to unhide.
  • Then, right-click on the mouse and select Unhide option.

Using Context Menu in Excel

  • You have to repeat the same process for other hidden rows.
  • Finally, you will be able to unhide the rows like the following.

Read More: Formula to Hide Rows in Excel (7 Methods)


Similar Readings


3. Unhide Multiple Rows by Double-Clicking

Double-clicking is often the fastest way to reveal multiple rows. This strategy removes the need for selection.

📌 Steps:

  • When you hover the mouse over the hidden rows headings and double-click, the mouse pointer will become a split two-headed row.

Unhide Multiple Rows by Double-Clicking

  • You have to repeat the same process for other hidden rows.
  • Finally, you will be able to unhide the rows like the following.

Unhide Multiple Rows by Double-Clicking

Read More: How to Hide and Unhide Rows in Excel (6 Easiest Ways)


4. Utilizing Name Box in Excel

Using the name box, you can spot hidden rows in a worksheet quite easily.  Let’s walk through the steps to find out how to reveal multiple rows in Excel.

📌 Steps:

  • To unhide cell B6, type its name in the Name Box adjacent to the formula bar, and press Enter.

Utilizing Name Box in Excel

  • The green line indicates that cell B6 is now selected in the following image.

Utilizing Name Box in Excel

  • Go to the Home tab, and select Format. Then select Hide & Unhide from the menu and finally select Unhide Rows.

Utilizing Name Box in Excel

  • You have to repeat the same process to unhide the other hidden rows.
  • Finally, you will be able to unhide the rows like the following.


5. Keyboard Shortcut to Unhide Multiple Rows

We can also unhide the rows using a keyboard shortcut. Let’s walk through the steps to find out how to reveal multiple rows in Excel.

📌 Steps:

  • In the first step, select the rows including those above and below the one we want to reveal.
  • Next, press Ctrl+Shift+9 from the keyboard.

Keyboard Shortcut to Unhide Multiple Rows

  • You have to repeat the same process for other hidden rows.
  • Finally, you will be able to unhide the rows like the following.

Keyboard Shortcut to Unhide Multiple Rows

Read More: Shortcut to Unhide Rows in Excel (3 Different Methods)


6. Changing Row Height to Show Multiple Hidden Rows

Here, we demonstrate another method to show hidden rows by changing the Excel row height. Let’s walk through the steps to find out how to reveal multiple rows in Excel.

📌 Steps:

  • Firstly, to select all rows from the worksheet, click the Select All button.

Changing Row Height to Show Multiple Hidden Rows

  • Go to the Home tab, and select Format. Then select Row Height from the drop-down menu.

Changing Row Height to Show Multiple Hidden Rows

  • When the Row Height dialogue box appears, enter your desired row height on the Row height option.

Finally, you will be able to unhide the rows like the following.

Changing Row Height to Show Multiple Hidden Rows

Read More: [Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)


7. Using ‘AutoFit Row Height’ Command

Here, we illustrate another method to show hidden rows by changing the Excel autofit row height. Let’s walk through the steps to find out how to reveal multiple rows in Excel.

📌 Steps:

  • Firstly, to select all rows from the worksheet, click the Select All button.

Using AutoFit Row Height Option

  • Go to the Home tab, and select Format. Then select AutoFit Row Height from the drop-down menu.

Using AutoFit Row Height Option

Finally, you will be able to unhide the rows like the following.


8. Show All Hidden Rows in Excel Worksheet

If we want to unhide all rows in the whole worksheet, you have to follow the following steps.

📌 Steps:

  • Firstly, to select all rows from the worksheet, click the Select All button.

Show All Hidden Rows in Excel Worksheet

  • Then, right-click on the mouse and select Unhide option.

Show All Hidden Rows in Excel Worksheet

Finally, you will be able to unhide the rows like the following.

Read More: Unhide All Rows Not Working in Excel (5 Issues & Solutions)


9. Embedding VBA Code to Unhide Multiple Rows in Excel

By using a simple code, you will be able to unhide multiple rows in Excel. You have to follow the following steps.

📌 Steps:

  • Firstly, press Alt+F11 to open the VBA editor. Select Insert > Module.

Embedding VBA Code to Unhide Multiple Rows in Excel

  • Next, you have to type the following code
Sub unhide_Multiple_rows()
Selection.EntireRow.Hidden = False
End Sub
  • Afterward, close the Visual Basic window, and to select all rows from the worksheet, click the Select All button.

Embedding VBA Code to Unhide Multiple Rows in Excel

  • After that press ALT+F8.
  • When the Macro dialogue box opens, select unhide_Multiple_rows in the Macro name. Click on Run.

Finally, you will be able to unhide the rows like the following.

Embedding VBA Code to Unhide Multiple Rows in Excel

Read More: Excel VBA: Unhide All Rows in Excel (5 Practical Examples)


Conclusion

That’s the end of today’s session. I strongly believe that from now you may unhide multiple rows in Excel. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib

Saquib

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo