Skip to content
CtrlKFind a shortcut

Insert Column Shortcut Excel Users Need

ExcelExcelColumnsChecked 2 Nov 2026

Select the column

CtrlSpace

Insert to its left

CtrlPlus

Ribbon keys

AltHI

Then C, one after another

The insert column shortcut excel provides is Ctrl + Space to select the column, followed by Ctrl + Plus. A blank column appears to the left of the selected one, and everything to the right moves over by one.

With only a cell selected, Ctrl + Plus asks what to insert; press C for entire column and Enter. To add three columns, select three before pressing the keys.

Quick facts

  • Select column

    Ctrl + Space

  • Insert

    Ctrl + Plus

  • From a single cell

    Ctrl + Plus, then C

  • Ribbon

    Alt, then H, then I, then C

  • Repeat

    F4

  • Delete a column

    Ctrl + Minus

Insert column shortcut excel steps

  1. Click a cell in the column that should move to the right.
  2. Press Ctrl + Space. The whole column is selected.
  3. Press Ctrl + Plus, the key with = on it, or the plus on the number pad.
  4. A new empty column appears on the left.

If Ctrl + Space switches your keyboard language instead, Windows has that hot key set; click the column letter with the mouse or use the ribbon keys.

All the ways to add a column

Insert column keys
SituationKeys
Column selectedCtrl + Plus
Only a cell selectedCtrl + Plus, then C, then Enter
Ribbon sequenceAlt, then H, then I, then C
Repeat elsewhereF4
Add a column to a tableType in the column just right of the table

Add several columns at once

Select as many columns as you need to add: Ctrl + Space, then Shift + Right for each extra one. Ctrl + Plus inserts that many blank columns to the left. This keeps formatting tidy because the new columns copy the format of the column on their left.

In a formatted table, typing a heading in the first empty column to the right adds it to the table automatically, with the same style and filters.

Formulas after inserting columns

References inside existing formulas move along with the data, so =SUM(B2:D2) becomes =SUM(B2:E2) if you insert inside that range. Inserting just outside the range does not extend it, so check row totals after adding a column at the edge. Tables avoid this problem; see AutoSum for checking totals.

When insert column fails

Problems and fixes
ProblemFix
Cannot shift nonblank cellsThe last column, XFD, has data; clear it
A row was inserted insteadYou selected a row; press Ctrl + Z and use Ctrl + Space
Ctrl + Space changes languageChange the Windows input hot key, or use Alt, H, I, C
Insert greyed outSheet protected or several sheets grouped
A teacher needs a new Practical marks column before Total. She clicks the Total column, presses Ctrl + Space and Ctrl + Plus, types the heading, and the totals formula stretches to include the new marks.

Insert copied columns without overwriting

To move a column of data into the middle of a sheet without replacing anything, copy it with Ctrl + C (or cut with Ctrl + X), select the column where it should go, and press Ctrl + Plus. Excel inserts the copied cells and pushes the existing columns to the right, instead of pasting over them. This is the cleanest way to reorder columns, for example moving a Phone column next to Name in a customer list, and it keeps every formula pointing to the right data.

Frequently asked questions

What is the shortcut to insert a column in Excel?
Ctrl + Space, then Ctrl + Plus.
Does the new column go left or right?

Left of the selected column.

How do I add a column without selecting it first?

Press Ctrl + Plus, then C, then Enter.

How do I insert many columns at once?

Select that many columns first, then press Ctrl + Plus.

What are the ribbon keys for insert column?
Alt, H, I, C.
How do I add a column in Excel for Mac?

Control click the column letter and choose Insert.