Ctrl+Shft+9
1. To unhide all hidden rows in Excel, navigate to the "Home" tab.
2. Click "Format," which is located towards the right hand side of the toolbar.
3. Navigate to the "Visibility" section. ...
4. Hover over "Hide & Unhide."
5. Select "Unhide Rows" from the list.
First need to select all cells:
Press Ctrl + A Then use any of the following:
Method one:
Press Ctrl + Shift + 9
Method two:
Press "ALT" + H + O + U + O // each key at a time
Method three:
Go to "Home" → "Format" → "Hide & Unhide" → "Unhide Rows"