Shows the hidden rows inside the selection. Select the rows on both sides of the hidden ones first, or press Ctrl+A to unhide every row on the sheet. Ctrl+9 hides rows.
Questions
Is there a shortcut to unhide columns?
Ctrl+Shift+0 unhides columns in Excel, but Windows often uses that combination to switch keyboard layouts, so it may do nothing. Right-click the column headers and choose Unhide instead.
More Format shortcuts
- Apply the Currency formatCtrl+Shift+4
- Apply the Date formatCtrl+Shift+3
- Open Format CellsCtrl+1
- Group rows or columnsAlt+Shift+Right
- Hide the selected columnsCtrl+0
- Hide the selected rowsCtrl+9
- Apply the Number formatCtrl+Shift+1
- Add an outline borderCtrl+Shift+7
- Apply the percent formatCtrl+Shift+5
- Apply the Scientific formatCtrl+Shift+6
- Apply strikethroughCtrl+5
- Apply the Time formatCtrl+Shift+2
- Ungroup rows or columnsAlt+Shift+Left