Home·Keyboard shortcuts

Excel · Unhide the hidden columns

Rows

Windows · Linux

Ctrl+Shift+0

Mac

Cmd+Shift+)

Brings hidden columns back; on Windows the keyboard-layout switcher often swallows Ctrl+Shift+0 so it looks broken, and rows use Ctrl+Shift+9 instead.

Group
Rows
Keys held
3

Excel diverges most on the Mac. F4 for absolute references is Cmd+T there, and a few Ctrl combinations stay Ctrl rather than becoming Cmd.

Reading the key names

  • Keys joined by + are pressed together: Ctrl+Shift+P means hold Ctrl and Shift, then P.
  • On a Mac, Cmd is ⌘, Option is ⌥ (labelled Alt on some keyboards), Control is ⌃ and Shift is ⇧.
  • Windows Ctrl usually becomes Cmd on a Mac, but not always — this reference lists both combinations separately.
  • With a Korean, Japanese or Chinese input method active, shortcuts built on letter keys may not fire. Switch to Latin input and try again.
  • When a combination does nothing, another program has often claimed it as a global shortcut first.

Common questions

Q. What is the shortcut for Unhide the hidden columns in Excel?

Brings hidden columns back; on Windows the keyboard-layout switcher often swallows Ctrl+Shift+0 so it looks broken, and rows use Ctrl+Shift+9 instead. It is Ctrl+Shift+0 on Windows and Cmd+Shift+) on a Mac.

Q. Is it the same on Windows and Mac?

No — Ctrl+Shift+0 on Windows, Cmd+Shift+) on a Mac.

Q. How many keys is that?

3 pressed together. The combination sits under Rows in Excel.

Shortcuts nearby