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

Windows shortcut: Ctrl+Shift+0

Mac

Ctrl
⇧
0

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

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

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

Practice

This shortcut conflicts with browser-reserved keys here, so this page shows the reference only.

Browse Browser-Safe PracticeStart Function Practice

Usage Tip

Reveal hidden columns.

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 Row

Same category
Ctrl + Shift + 9

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 Column?

Windows: Ctrl+Shift+0. Mac: Ctrl+Shift+0.

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?

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 Column?

A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.

← Back to ListExcelGym Home