The simplest way to add a column

Right-click on the column letter where you want the new column to appear — say you right-click on column C. A menu pops up. Click Insert 1. Excel slides a blank column in at that spot and pushes everything that was in column C over to the right. That's it.

The new column takes on the same format as the column you right-clicked on, so if column B had dollar signs, your new column will too. If you don't want that formatting, you can undo it right away by pressing Ctrl+Z (or Cmd+Z on Mac), then use a different method below.

If you need to add multiple columns at once, click on the first column letter, hold Shift, and click on the last column letter you want to add. Then right-click and choose Insert. Excel will add that many blank columns all at once.

Key Takeaways

  • Right-click the column letter where you want the new column to go, then click Insert to slide a blank column in at that spot.
  • The new column copies the formatting of the column you right-clicked on, which you can undo when ready if you don't want it.
  • To add multiple columns at once, select several column letters by clicking the first, holding Shift, and clicking the last, then right-click and insert.
  • You can also add a column at the far right by clicking the first empty column letter and typing data into it without any menu at all.

Adding a column at the end of your data

If you want to add a column to the right of everything you already have, you don't need to right-click anything. Just click on the first empty column letter — if your data ends at column E, click on column F. Start typing your header or data. Excel treats it as a new column automatically.

This method is the fastest when you're building a spreadsheet from scratch or adding one more column to the end. It's also the cleanest because you're not moving anything around.

Adding a column in the middle without copying formatting

Sometimes the column next to where you want to insert will have formatting you don't want to copy — bold headers, colored cells, or number formats. Right-click the column letter anyway, click Insert, and then when ready press Ctrl+Z to undo. This sounds backwards, but it works: Excel will have created the column, and undoing just removes the formatting copy.

A cleaner way is to right-click, choose Insert, and then right away click the small clipboard icon that appears at the bottom right of the new column. A menu will say Don't Format. Click that. Your new column stays blank with no formatting borrowed from its neighbor.

Inserting a column using the menu

If right-clicking doesn't work on your computer or you prefer menus, click on the column letter to select the whole column. Then go to the Home tab at the top, find the Insert button (it's usually in a group with other buttons), click the small arrow next to it, and choose Insert Sheet Columns.

This does the same thing as right-clicking, but it's one more step. Most people find right-clicking faster once they know it's there.

What happens to formulas when you add a column

If you have a formula in column D that adds up columns A, B, and C, and you insert a new column between B and C, Excel automatically updates that formula to include the new column. The formula changes from =A1+B1+C1 to =A1+B1+C1+D1 (or whatever the new column letter is). This usually saves you work, but check your formulas after inserting to make sure they still do what you want.

If you insert a column after a formula — say you insert column E when your formula is in column D — the formula stays the same and doesn't include the new column. You have to add it by hand if you need it.

Deleting a column you added by mistake

Right-click the column letter and choose Delete. The columns to the right slide left to fill the gap. If you deleted the wrong column, press Ctrl+Z when ready to undo.

Be careful: deleting a column erases all the data in it. Excel will warn you if the column has data, but if it's blank, it just deletes without asking. If you're not sure what's in a column, click the column letter first to see what's there before you delete.

Frequently Asked Questions

Can I add a column between two columns without moving the data?

No. When you insert a column, everything to the right shifts over. If you want to keep data in the same place, you have to move it by hand first or use a different column layout. Think of it like inserting a page in the middle of a book — everything after it moves forward.

Why did my formula break when I added a column?

If you inserted a column after the formula instead of before it, the formula doesn't automatically update. Click on the cell with the formula and edit it by hand to include the new column. If you inserted the column before the formula, it should have updated on its own — check that it did by clicking the cell and looking at the formula bar at the top.

How do I add a column with a specific width?

Add the column first using any method above. Then position your mouse on the line between that column's letter and the next column's letter at the very top. Your cursor will change to a resize arrow. Click and drag left or right to make the column wider or narrower. Double-click that same line and Excel will auto-fit the column to the width of the longest entry in it.

Can I add a column to the left of column A?

Yes. Right-click on column A and choose Insert. A new column A appears, and what was column A becomes column B. This is useful if you realize you need a first column for row numbers or labels after you've already started building your sheet.