Insert a column in Excel

Insert a column in Excel: Ctrl+Space, Ctrl+Shift+= (Mac: Control+Space, Cmd+Shift+=)

Windows	`Ctrl+Space, Ctrl+Shift+=`
Mac	`Control+Space, Cmd+Shift+=`
Group	grouping and structure

Practice this shortcut

Drill: Insert a column. Free, no sign-up.

What it does and when to use it

With a whole column selected, Ctrl+Shift+= inserts a blank column to its left without a dialog. Everything to the right shifts and the formulas adjust.

The common mistake

Inserting with a cell selected and clicking through the shift dialog. Select the column first and there is no dialog.

Related shortcuts

Delete a blank row Shift+Space, Ctrl+-
Group rows Alt+Shift+Right arrow
Ungroup rows Alt+Shift+Left arrow
Collapse the groups Alt, A, H
Insert a sheet Shift+F11
The printable cheat sheet

Questions

How do I insert a column between two others?

Select the column on the right of the gap you want (Ctrl+Space), then Ctrl+Shift+=.

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