Here's how to unhide rows:
- Select the rows before and after the hidden rows (rows 2 and 4 in our example).
- Right-click the selected row headers and pick Unhide Rows.
How do I unhide all hidden rows in Excel?
How to unhide all rows in Excel
- To unhide all hidden rows in Excel, navigate to the "Home" tab.
- Click "Format," which is located towards the right hand side of the toolbar.
- Navigate to the "Visibility" section. ...
- Hover over "Hide & Unhide."
- Select "Unhide Rows" from the list.
How do I unhide rows quickly?
How to unhide all rows in Excel
- Press Ctrl + Shift + 9 (the fastest way).
- Select Unhide from the right-click menu (the easiest way that does not require remembering anything).
- On the Home tab, click Format > Unhide Rows (the traditional way).
