Hide Rows in Excel (Ctrl + 9)
Hiding rows allows you to temporarily remove them from view without deleting data, which is useful for reports, presentations, or simplifying worksheet views.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + 9 | Cmd + 9 |
What Does This Shortcut Do?
The shortcut hides the selected row(s). Hidden rows can later be unhidden using the appropriate shortcut or context menu.
How to Hide Rows
- Select the row(s) you want to hide
- Press Ctrl + 9 (Windows) or Cmd + 9 (Mac)
- The selected row(s) will be hidden immediately
Tips & Best Practices
- Hidden rows still contain data and formulas; calculations remain unaffected
- Use hiding to focus only on relevant rows in large worksheets
- Combine with grouping for organized worksheet management
FAQ
- Q: Can I hide multiple rows at once?
- A: Yes, select multiple rows before using the shortcut.
- Q: Will hiding rows affect formulas?
- No, formulas referencing hidden rows will continue to work normally.
- Q: How do I unhide rows?
- Use Ctrl + Shift + 9 (Windows) or Cmd + Shift + 9 (Mac), or right-click the row header and select "Unhide".