Just remove the filter from the worksheet to unhide all the hidden rows in Excel. In this situation, the traditional method won’t work. If you see the row numbers are in blue color that means a filter is applied to your worksheet.
Sometimes, you may face some troubles unhiding the hidden rows in your Excel worksheet. It will unhide that particular row from the top. We are using the keyboard shortcut.Īfter you have selected Cell A1, press Ctrl+Shift+9. In this time, follow any of the methods that we showed earlier. To unhide this, type “ A1” in the Name Box and press Enter. Now, what if the rows are located at the top like the following? Follow any of these methods to unhide specific rows.įrom these examples, you have seen that we had hidden rows in the middle. It will successfully unhide rows 6 and 7 respectively. After that, you will see the context menu. We are using the context menu here to unhide rows. If you haven’t read them, please read them first. Then follow any method to unhide rows that we showed earlier. This method resembles the methods that we showed earlier.įirst, highlight the rows on either side of the row you want to unhide. Just one double click will unhide all of them.Īnother way to uncover particular rows from a worksheet is by highlighting the rows. The main benefit of this method is you don’t have to highlight the rows. You will see a split two-headed arrow.Īfter that, it will uncover the invisible rows 6 and 7. After you have found the hidden rows, hover the mouse over the interaction of the rows. We are just showing some simple ways again. In the previous sections, we showed you to unhide all hidden rows in your Excel spreadsheet. Next, select Display_all_hidden_rows / Display_all_rows_in_Workbook.įinally, these VBA codes will successfully expose all the hidden rows in your Excel worksheet/workbook.After that, press Alt+F8 on your keyboard to open the Macro dialog box.If you have multiple worksheets in your workbook and unhide all rows from them, type the following code: Sub Display_all_rows_in_Workbook() But, I recommend you learn and apply this method also. Unhide All Rows in Excel Using Keyboard ShortcutĪnother beneficial way to unhide all rows is using the keyboard shortcut. It is also pretty simple to unhide all the hidden rows or columns.įinally, this method will successfully unhide all the hidden rows from the Excel worksheet.ģ. You can also unhide all rows from the context menu after right-clicking the mouse. In the end, it will unhide all the rows from the whole Excel spreadsheet.Ģ. Next, click on the Hide & Unhide After that, click on Unhide Rows button.After you have selected all rows, go to the Cells group from the Home tab.First, click on the Select All button to select all rows from the worksheet.Now, the most used method to unhide all hidden rows is using the ribbon. We will unhide all the rows using the following methods. We will use this dataset in the following sections: It will definitely develop your Excel knowledge.
I recommend you learn and apply all the methods to your spreadsheet. In the following sections, I will provide you with four easy ways to unhide all hidden rows in Excel. To choose the whole worksheet again, press Ctrl+A again. But, if the cursor is in one of the adjacent cells with data, it will only select the dataset. If you point the cursor in a blank cell, this shortcut will select the whole spreadsheet. Click the Select All button (the little triangle at the intersection of rows and columns)Ī note to remember is, in Microsoft Excel, this shortcut acts differently in distinct circumstances.