Excel hide row shortcut: Ctrl + 9
Hide the selected rows, and bring them back with Ctrl + Shift + 9.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
* Based on the keyboard layout, not tested on a real keyboard (only the Croatian one was tested). If the shortcut does not work, use the matching button on the ribbon.
What it does
Ctrl + 9 hides the selected rows, or the row of the active cell. The data is not deleted, the row number just disappears from the list. Ctrl + Shift + 9 shows hidden rows again when the rows around them are selected.
When to use it
Use it to hide helper rows, old entries or details while you print or share a sheet. Hidden rows still count in formulas such as SUM.
How to do it
- Click a cell in the row, or select the row with Shift + Space.
- Press Ctrl + 9. The row disappears.
- To bring it back, select the rows above and below it and press Ctrl + Shift + 9.
A quick example
In the orders table, click a cell in row 4, press Shift + Space, then Ctrl + 9. Row 4 disappears and row 5 sits right under row 3. Select rows 3 to 5 and press Ctrl + Shift + 9, and row 4 is back.
Hide, filter and delete
Hiding keeps the data and only changes what you see. A filter hides rows by a rule and can be switched off with one click. Delete removes the row for good. Pick hiding for rows you want out of sight for a moment, and remember that hidden rows are still there when you copy a range, so check before you share.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar. In a browser Ctrl + 9 may be taken by the browser, so click into the sheet before you press it.
- You cannot unhide it: select the rows above and below the hidden one, then press Ctrl + Shift + 9, or right-click the selection and choose Unhide.
- Ctrl + 0 does not hide a column in Excel for the web: right-click the column letter and choose Hide.
- On a Mac use Command + 9 to hide and Command + Shift + 9 to unhide.
- Nothing happens at all: on Windows, Ctrl + Shift can switch the keyboard language, so Excel never gets the keys. If the language indicator in the taskbar changes when you press them, turn that shortcut off under Settings, Time & language, Typing, Advanced keyboard settings, Input language hot keys (the names can differ a little by Windows version).
Quick answers
What is the shortcut to hide a row in Excel?
Select the row and press Ctrl + 9. On a Mac use Command + 9.
How do I unhide a row?
Select the rows above and below the hidden one, then press Ctrl + Shift + 9. You can also right-click the selection and choose Unhide.
Are hidden rows deleted?
No. The data stays in the file and still counts in formulas such as SUM. Only the row is hidden from view.

