Unhide Rows in Excel (Ctrl + Shift + 9)
Unhiding rows restores previously hidden rows to view, allowing you to work with all your data again.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + 9 | Cmd + Shift + 9 |
What Does This Shortcut Do?
The shortcut unhides any hidden rows in the selected range or adjacent to selected rows.
How to Unhide Rows
- Select the rows around the hidden rows
- Press Ctrl + Shift + 9 (Windows) or Cmd + Shift + 9 (Mac)
- The hidden rows will become visible again
Tips & Best Practices
- Ensure you select rows above and below the hidden rows for the shortcut to work
- Use this after hiding rows for temporary data management
- You can also right-click the row headers and choose "Unhide"
FAQ
- Q: Can I unhide multiple hidden rows at once?
- A: Yes, select the surrounding rows and use the shortcut to unhide all hidden rows in that range.
- Q: Will unhidden rows restore formatting and formulas?
- Yes, all formatting and formulas remain intact.
- Q: Is there an alternative way to unhide rows?
- Yes, right-click the row header of the hidden row range and select "Unhide".