Hide selected rows in selection
Master this Excel shortcut with our comprehensive guide
Hide/Unhide (Rows, Columns, Objects) Shortcuts
Ctrl + 9
⌘ + Option + 9
How to Use This Shortcut
Keyboard Shortcut
Ctrl + 9
Instructions
1. Select the row(s) you want to hide
2. Press Ctrl + 9
3. Selected rows are hidden
2. Press Ctrl + 9
3. Selected rows are hidden
Keyboard Shortcut
⌘ + Option + 9
Instructions
1. Highlight rows
2. Press Command + Option + 9
3. The selected rows become hidden
2. Press Command + Option + 9
3. The selected rows become hidden
💡 Pro Tip: Use this to temporarily hide rows without deleting data.
More Hide/Unhide (Rows, Columns, Objects) Shortcuts
Ctrl + 0
Ctrl + Shift + 9
Ctrl + Shift + 0