Right-click on the column letter to insert a new column

To add a column in Excel, right-click on the column letter where you want the new column to appear. A menu will pop up. Click Insert. Excel will create a blank column to the left of the column you right-clicked, and shift everything that was there one column to the right.

If you want the new column to go between two existing columns, right-click on the column letter of whichever column should move to the right. For example, if you want to insert a column between Column B and Column C, right-click on the C. The new column becomes the new C, and the old C becomes D.

You can also select multiple column letters at once by clicking one, holding Shift, and clicking another. Right-click and insert — Excel will add as many new columns as you selected, all at once.

Key Takeaways

  • Right-click the column letter where you want the new column to appear, then click Insert to add a blank column to its left.
  • Everything in that column and to the right shifts one column over, so formulas and references update automatically.
  • You can select multiple column letters and insert several columns at the same time by holding Shift while clicking.
  • The Home tab in the ribbon also has an Insert button if you prefer not to right-click.
  • Deleting a column works the same way — right-click the column letter and choose Delete.

Using the ribbon menu instead of right-clicking

If you prefer using the menu at the top of Excel, click on the column letter to select the entire column. Then go to the Home tab in the ribbon. Look for the Insert button in the Cells group. Click the small arrow next to it and choose Insert Sheet Columns.

This method works the same way as right-clicking — the new column appears to the left of the column you selected, and everything shifts right. Some people find the ribbon easier to see, especially if they are new to Excel.

What happens to your data and formulas when you insert

When you insert a column, Excel automatically updates any formulas that reference the columns around it. If you had a formula in Column D that added up Column B and Column C, and you insert a new column between B and C, that formula still works correctly — it now adds the new column and the old Column C (which is now Column D).

The new column itself is blank. You fill it in with whatever data or formulas you need. If you insert a column in the middle of existing data, you will need to decide what goes in that column before you can use the spreadsheet the way you intended.

Inserting a column at the far right of your data

If you want to add a column after all your existing data, you do not have to insert — you can just click on the first empty column to the right and start typing. Excel treats any column you use as part of your spreadsheet.

However, if you want to insert a column at the end and have it shift other columns, select the column letter just past where you want to stop, then insert. For example, if your data ends in Column E and you want a new column to be Column F, click on Column G and insert.

Undoing an accidental insert

If you insert a column by mistake, press Ctrl+Z (or Cmd+Z on a Mac) when ready. This undoes the insert and brings back any columns that shifted. You can undo multiple times if you need to go back several steps.

If you have already saved the file after inserting, undo will not work. In that case, you can delete the column you added by right-clicking its letter and choosing Delete, then manually move any data back if needed.

Adding multiple columns at once

Select as many column letters as you want to add. Click the first column letter, hold Shift, and click the last column letter in your selection. All the columns in between will highlight. Right-click and choose Insert, and Excel will add that many new blank columns.

For example, if you need to add three columns, click on Column C, hold Shift, and click on Column E. You now have three columns selected. Right-click and insert, and three new columns appear to the left of Column C. The old C, D, and E become D, E, and F.

Frequently Asked Questions

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

Yes. Click on Column A (the first column), then right-click and choose Insert. A new Column A appears, and everything that was in Column A moves to Column B. This works the same way as inserting anywhere else.

What if I insert a column and my formulas break?

Excel usually updates formulas automatically when you insert a column. If a formula is not working after you insert, check whether it references the columns you moved. You may need to edit the formula to include the new column in its range, or delete and rewrite it.

Can I insert a column between two cells instead of between two whole columns?

No. Excel inserts entire columns, not partial ones. If you need to add data in a specific spot, you may need to rearrange your spreadsheet or use a different approach, like adding a new row instead.

Does inserting a column cost money or require saving?

No. Inserting a column is a basic spreadsheet function that does not cost anything. You can insert as many columns as you want. You only need to save if you want to keep the changes — if you close without saving, the inserted column disappears.