What is the shortcut for Unhide Column?
Windows: Ctrl+Shift+0. Mac: Cmd+Shift+0.
📊Excel Shortcut
Unhide Column
Detailed guide to use "Unhide Column" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Ctrl+Shift+0
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+0
Mac
⌘+⇧+0
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+0
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: B2Hidden Cols: CSheet: Sheet1Step 1/2
You can scroll the sheet horizontally
↶↷BIUGeneral
Name Box
B2
Formula Bar
fx12◢ | A | B | || | D | E |
|---|---|---|---|---|---|
| 1 | Item | Qty | Total | Owner | |
| 2 | Pen | 12 | 960 | Aki | |
| 3 | Pad | 6 | 720 | Mina | |
| 4 | File | 4 | 1200 | Ken | |
| 5 | Box | 3 | 1350 | Sora |
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 Column is executed
Practice
This shortcut conflicts with browser-reserved keys here, so this page shows the reference only.
Usage Tip
Reveal hidden columns.
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 Row
Same categoryCtrl + Shift + 9
Toggle AutoFilter
Same categoryCtrl + Shift + L
Open Filter Menu
Same categoryAlt + Down
More In This Category
FAQ
How do I use Unhide Column?
Use it on the active workbook or selection to keep routine work keyboard-first.
What shortcuts should I practice after Unhide Column?
Practice save, copy, and paste next and you can move through common Excel work much faster.
Where can I practice Unhide Column?
This shortcut conflicts with browser keys and has no individual drill. Open the practice list to choose a supported shortcut.
What is the action preview for Unhide Column?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.