What is the shortcut for Unhide Row?
Windows: Ctrl+Shift+9. Mac: Cmd+Shift+9.
📊Excel Shortcut
Unhide Row
Detailed guide to use "Unhide Row" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Ctrl+Shift+9
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Home
Del
End
PgUp
PgDn
↑
←
↓
→
Windows: Ctrl+Shift+9
Mac
⌘+⇧+9
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
⌃
⌘
⌥
⌥
⌘
Fn
⌃
↑
←
↓
→
Mac: Cmd+Shift+9
In Action
This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.
Windows Excel example (US key symbols). For Mac or other keyboard layouts, see the keys at the top of the page. Number formats may vary by region.
Auto-playing example
Active: A2Hidden Rows: 3Sheet: Sheet1Step 1/2
You can scroll the sheet horizontally
↶↷BIUGeneral
Name Box
A2
Formula Bar
fxPen◢ | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Qty | Price | Total |
| 2 | Pen | 12 | 80 | 960 |
| 4 | File | 4 | 300 | 1200 |
| 5 | Box | 3 | 450 | 1350 |
| 6 | Memo | Ready | 2026-03-28 |
Sheet1
Ready100%
Basic Info
- Category
- Other
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Unhide Row is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Reveal hidden rows.
Related Shortcuts
Close Workbook
Same categoryCtrl + W
Insert Cells/Rows/Columns
Same categoryCtrl + Shift + +
Delete Cells/Rows/Columns
Same categoryCtrl + -
Hide Row
Same categoryCtrl + 9
Hide Column
Same categoryCtrl + 0
Unhide Column
Same categoryCtrl + Shift + 0
Toggle AutoFilter
Same categoryCtrl + Shift + L
Open Filter Menu
Same categoryAlt + Down
More In This Category
FAQ
How do I use Unhide Row?
Use it on the active workbook or selection to keep routine work keyboard-first.
What shortcuts should I practice after Unhide Row?
Practice save, copy, and paste next and you can move through common Excel work much faster.
Where can I practice Unhide Row?
Use the page button to start a focused drill right away. If you switch to full practice, you can review save, copy, and paste in the same flow.
What is the action preview for Unhide Row?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.