Saquib Ahmad Shuvo
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.
📌 Steps:
- Firstly, to select all rows from the worksheet, click the Select All Button.
- 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.
Read More: [Fix]: Unable to Unhide Rows in Excel (4 Solutions)
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.
📌 Steps:
- Firstly, select the rows that you want to unhide.
- Then, right-click on the mouse and select Unhide option.
- 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
- VBA to Hide Rows Based on Cell Value in Excel (14 Examples)
- Hide Duplicate Rows Based on One Column in Excel (4 Methods)
- VBA to Hide Rows Based on Criteria in Excel (15 Useful Examples)
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.
- 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: 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.
- The green line indicates that cell B6 is now selected in the following image.
- Go to the Home tab, and select Format. Then select Hide & Unhide from the menu and finally select Unhide Rows.
- 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.
- 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: 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.
- Go to the Home tab, and select Format. Then select Row Height from the drop-down menu.
- 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.
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.
- Go to the Home tab, and select Format. Then select AutoFit Row Height from the drop-down menu.
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.
- Then, right-click on the mouse and select Unhide option.
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.
- 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.
- 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.
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!
