Unhide hidden rows in selection
Master this Excel shortcut with our comprehensive guide
Hide/Unhide (Rows, Columns, Objects) Shortcuts
Ctrl + Shift + 9
⌘ + Option + Shift + 9
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + 9
Instructions
1. Select the rows around the hidden rows
2. Press Ctrl + Shift + 9
3. Hidden rows are revealed
2. Press Ctrl + Shift + 9
3. Hidden rows are revealed
Keyboard Shortcut
⌘ + Option + Shift + 9
Instructions
1. Select the surrounding rows
2. Press Command + Option + Shift + 9
3. Hidden rows become visible
2. Press Command + Option + Shift + 9
3. Hidden rows become visible
💡 Pro Tip: Quickly restore hidden rows to continue editing.
More Hide/Unhide (Rows, Columns, Objects) Shortcuts
Ctrl + 9
Ctrl + 0
Ctrl + Shift + 0