📊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
⇧
9

Windows shortcut: Ctrl+Shift+9

Mac

Ctrl
⇧
9

Mac shortcut: Ctrl+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.

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

  1. 1Select the target cell/range if needed
  2. 2Press the highlighted keys shown above together
  3. 3Unhide Row is executed

Practice

Practice this shortcut and build reliable muscle memory.

Start Shortcut PracticeSee Practice ModesStart Function Practice

Usage Tip

Reveal hidden rows.

Related Shortcuts

Close Workbook

Same category
Ctrl + W

Insert Cells/Rows/Columns

Same category
Ctrl + Shift + +

Delete Cells/Rows/Columns

Same category
Ctrl + -

Hide Row

Same category
Ctrl + 9

Hide Column

Same category
Ctrl + 0

Unhide Column

Same category
Ctrl + Shift + 0

Toggle AutoFilter

Same category
Ctrl + Shift + L

Open Filter Menu

Same category
Alt + Down

More In This Category

Open Workbook

Ctrl + O

Print

Ctrl + P

Save

Ctrl + S
View Full Shortcut List

FAQ

What is the shortcut for Unhide Row?

Windows: Ctrl+Shift+9. Mac: Ctrl+Shift+9.

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.

← Back to ListExcelGym Home