Right-click the column header where you want the new column to go

To insert a column in Excel, first decide where you want it. Click on the column letter (A, B, C, and so on) of the column that will move to the right to make room for your new one. The entire column will highlight in blue.

Right-click on that column header. A menu will appear with several options. Click "Insert 1" (or "Insert" if you're using a Mac). Excel will create a new blank column and shift everything that was in that column one space to the right.

Key Takeaways

  • Click the column letter to select an entire column, then right-click and choose Insert to add a new column before it.
  • You can insert multiple columns at once by selecting multiple column headers before right-clicking.
  • The new column will be blank and will push any existing data in that column and columns to its right one position over.
  • If you insert a column in the middle of a formula, Excel automatically updates the formula to reference the new column position.

Inserting multiple columns at the same time

If you need to add more than one column, you don't have to insert them one at a time. Click on the first column header where you want the new columns to start, then hold Shift and click on another column header to the right. This selects a range of columns.

Right-click anywhere in your selected columns and choose Insert. Excel will add as many new blank columns as you had selected. For example, if you selected columns D and E (two columns), Excel will insert two new blank columns before column D. This is much faster than inserting columns individually when you need several at once.

What happens to your data when you insert a column

When you insert a column, everything in that column and to its right shifts one column over. Your data stays intact — nothing is deleted. If you had a formula in column D that referred to column C, and you insert a new column between them, Excel updates that formula automatically to still refer to the correct cell.

The new column itself is always blank. You can then type or paste data into it, or leave it empty if you just needed to create space for future use. This automatic updating of formulas is one reason inserting is safer than manually moving data around.

Using the menu instead of right-clicking

If right-clicking feels awkward, you can use the menu at the top instead. Select the column where you want the new one to go, then click the "Home" tab (if it's not already selected). Look for a button that says "Insert" with a small arrow next to it. Click that arrow and choose "Insert Sheet Columns".

This method works the same way as right-clicking — it inserts a new blank column before the one you selected and shifts everything else to the right. Some people find the menu easier to use than right-clicking, especially if they're working on a laptop or touchpad.

Undoing an accidental insertion

If you insert a column by mistake, press Ctrl+Z (or Cmd+Z on a Mac) right away to undo it. Excel will remove the column and put everything back where it was. You can undo multiple steps if you need to — just keep pressing Ctrl+Z until you're back to where you started.

If you've already saved your file after inserting the column, you won't be able to undo it. In that case, you can delete the column instead by right-clicking it and choosing Delete, or by selecting it and using the Home menu. Saving frequently is good practice, but it does mean you lose the ability to undo past saves.

Inserting a column at the very end of your data

If you want to add a column after all your existing data (rather than in the middle), you don't need to insert at all — just click on the first empty column to the right and start typing. Excel will treat it as part of your spreadsheet automatically.

However, if you want to insert a column before the last column for some reason, use the same right-click method. Select the last column with data, right-click, and choose Insert. The new column will appear before it, and your last column will shift one space to the right. This approach keeps your data organized when you realize you need a column in a specific position.

Frequently Asked Questions

Can I insert a column in the middle of a formula without breaking it?

Yes. Excel automatically updates formulas when you insert a column. If your formula referred to a cell in the old column C and you insert a new column between B and C, the formula will update to reference the new column C position.

What's the difference between inserting and just typing in an empty column?

There is no difference in the final result. If you type in an empty column next to your data, it becomes part of your spreadsheet. Inserting is useful when you need a column in a specific spot in the middle of existing data, or when you want to move existing columns over.

Can I insert a column at the beginning of my spreadsheet?

Yes. Click on column A (the first column), right-click, and choose Insert. A new blank column will become your new column A, and everything else shifts one column to the right.

What happens if I insert a column in a table or named range?

Excel expands the table or range to include the new column automatically. If your table had five columns and you insert a column in the middle, it now has six columns, and any formulas that reference the table adjust accordingly.