ShortcutdrillExcel shortcuts / formatting / Unhide columns
Unhide columns in Excel: Ctrl+Shift+0 (Mac: Cmd+Shift+0)
| Windows | Ctrl+Shift+0 |
|---|---|
| Mac | Cmd+Shift+0 |
| Group | formatting |
Drill: Unhide them. Pro drill. Twenty-five drills are free.
What it does and when to use it
Select across the hidden columns, then Ctrl+Shift+0 unhides them. If the shortcut is taken by the operating system, Alt, H, O, U, L does the same.
The common mistake
Selecting only the column before the hidden ones. The selection has to span the hidden columns on both sides.
Related shortcuts
- Bold the selection Ctrl+B
- Italic Ctrl+I
- Underline Ctrl+U
- Format as currency Ctrl+Shift+4
- Thousands separators and two decimals Ctrl+Shift+1
- The printable cheat sheet
Questions
Ctrl+Shift+0 does nothing. Why?
Windows uses it to switch keyboard layouts on some setups. Use Alt, H, O, U, L, or disable the layout shortcut in the language settings.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill