ShortcutdrillExcel shortcuts / formatting / Hide the selected columns
Hide the selected columns in Excel: Ctrl+0 (Mac: Cmd+0)
| Windows | Ctrl+0 |
|---|---|
| Mac | Cmd+0 |
| Group | formatting |
Drill: Hide the helper columns. Free, no sign-up.
What it does and when to use it
Ctrl+0 hides the columns of the selection. Helper columns stay in the model and out of the print. Ctrl+9 hides rows the same way.
The common mistake
Hiding a column that a formula on another sheet points at, then forgetting it exists. Group it instead (Alt+Shift+Right) so the outline shows there is something there.
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
Why does Ctrl+0 not work?
Some operating systems and browsers use Ctrl+0 for zoom. Use Alt, H, O, U, C instead, or change the system shortcut.
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