Hide & unhide rows and columns
Ctrl+9 hides rows and Ctrl+0 hides columns. Add Shift to unhide, after selecting cells on both sides of the hidden ones.
Try it: press the keys on this sheet
Windows and Mac keys
| Action | Windows | Mac |
|---|---|---|
| Hide rows | Ctrl+9 | ⌃9 |
| Unhide rows | Ctrl+Shift+9 | ⌃⇧9 |
| Hide columns | Ctrl+0 | ⌃0 |
| Unhide columns | Ctrl+Shift+0 | ⌃⇧0 |
Shortcut not working?
Ctrl+Shift+0 won't unhide columns
Windows uses this key for switching keyboard languages. Turn it off in Settings, Time & language, Typing, Advanced keyboard settings, Input language hot keys, or right-click the column header and choose Unhide.
Unhide does nothing
Select the rows or columns on both sides of the hidden ones first, or press Ctrl+A to select everything.
Row 1 is hidden and can't be selected
Type A1 in the Name Box, press Enter, then Ctrl+Shift+9.
Practise these and 30 more: play the shortcut trainer → or see the full cheat sheet.
Frequently asked questions
What is the shortcut to hide a row in Excel?
Select the row and press Ctrl+9. Ctrl+Shift+9 unhides it.
What is the shortcut to hide a column?
Select the column and press Ctrl+0. Ctrl+Shift+0 unhides it, if Windows allows.
How do I unhide all rows at once?
Press Ctrl+A to select the sheet, then Ctrl+Shift+9.