Unhide all rows in Excel
Identifying hidden rows requires you to look very carefully at all the row numbers.
This is cumbersome⏳
So you definitely want to use one of several techniques to unhide all rows at once.
1. Select the rows where you think there are hidden rows in between.
Since you can’t select the specific hidden rows, you need to drag “over” them with your cursor while holding down the left mouse button.
2. Right-click any of the selected rows.
3. Click Unhide.
That’s it – now all the hidden rows in between the rows you selected are visible💡
Unhide rows with shortcut
Unhiding rows can be done even faster than this!
After selecting the rows in step 1 above, you can use a shortcut to unhide rows instead of doing step 2 and 3.
So, select the rows and press Ctrl + Shift + 9.
Unhide rows hidden by autofilter
Sometimes rows are hidden because of another method: the autofilter.
With the autofilter, you can easily control which rows are visible (and which are hidden).
To unhide rows hidden by the autofilter, you don’t need to jump through all the hoops.
Simply go to the Data tab, and click the Clear button.