Adding a single column takes 30 seconds

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 left to add a column to the left of C, or Insert 1 right to add it to the right. The new column appears instantly, and everything that was in the columns to the right shifts over to make room.

That is the fastest way. If you prefer using the menu instead of right-clicking, click Insert at the top, then pick Column left or Column right. The result is the same either way.

Key Takeaways

  • Right-click a column letter and choose Insert 1 left or Insert 1 right to add a single column in seconds.
  • To add multiple columns at once, select several column letters first, then right-click and insert — Google Sheets adds as many columns as you selected.
  • New columns always push existing data to the right, so your formulas and references update automatically.
  • You can undo a column addition by pressing Ctrl+Z (or Cmd+Z on Mac) if you change your mind immediately.

Adding multiple columns at the same time

If you need to add three columns instead of one, select three column letters first. Click on column A, then hold Shift and click on column C. All three columns highlight in blue. Now right-click anywhere in the selection and choose Insert 3 left or Insert 3 right. Google Sheets adds exactly as many columns as you selected.

This saves time when you are building a spreadsheet from scratch and know you need a certain number of empty columns. You can also select non-consecutive columns by holding Ctrl (or Cmd on Mac) and clicking each one, then insert — but Google Sheets will add a column for each one you selected, which can create gaps in your layout.

What happens to your data and formulas

When you insert a column, everything to the right shifts over automatically. If column B had a formula that referenced column C, that formula updates itself to reference column D instead. You do not have to fix anything manually.

The new column itself is always empty. Google Sheets does not copy data from nearby columns or guess what should go there. You fill it in yourself, or leave it blank if you just needed the space for future use.

Inserting a column at the very end of your data

If you want to add a column after all your existing data — say you have data in columns A through E and want column F — you do not have to insert at all. Just click on cell F1 and start typing. Google Sheets treats any column you click on as part of your spreadsheet, whether it existed before or not.

Inserting is only necessary when you want the new column to go between existing columns, or when you want to shift everything to the right to make room. If you are just extending your spreadsheet to the right, clicking and typing is faster.

Undoing a column you added by mistake

If you inserted a column and immediately realized you did not want it, press Ctrl+Z (Windows) or Cmd+Z (Mac). The column disappears and everything shifts back. This works as long as you undo right away — if you have made other changes since the insertion, undo will reverse those too.

If you inserted a column with data in it and want to keep the data but remove the column, cut the data first, delete the column, then paste the data where you want it. This takes a few extra steps but preserves what you typed.

Deleting columns you no longer need

To remove a column, right-click its letter and choose Delete column. Everything to the right shifts left to fill the gap. If you delete multiple columns, select them all first (the same way you select them to insert), right-click, and choose Delete columns.

Deleted columns cannot be recovered unless you undo immediately with Ctrl+Z or Cmd+Z. If you have already made other changes, the undo history may not go back far enough. For this reason, it is safer to hide a column instead of deleting it if you are not sure you want it gone permanently. Right-click the column and choose Hide column — you can unhide it later if you change your mind.

Resizing columns after you add them

New columns are usually narrow by default. To make a column wider, position your cursor on the line between two column letters at the top — the cursor changes to a resize arrow. Click and drag to the right to widen the column, or double-click to auto-fit the width to whatever text is inside.

You can also right-click a column letter and choose Resize column, then type an exact width in pixels. This is useful when you want several columns to be exactly the same width for a consistent look.

Frequently Asked Questions

Can I add a column in the middle of my data without losing anything?

Yes. Right-click the column letter where you want the new column to appear and choose Insert left or Insert right. Everything shifts automatically, and no data is lost. Formulas that reference the shifted columns update themselves.

What is the difference between Insert 1 left and Insert 1 right?

Insert left puts the new column to the left of the column you right-clicked. Insert right puts it to the right. If you right-click column C and choose Insert left, the new column becomes C and the old C becomes D. If you choose Insert right, the new column becomes D.

Do I have to insert columns, or can I just use empty ones that already exist?

You can use empty columns that already exist — Google Sheets treats any column as usable whether you inserted it or not. Inserting is only necessary when you want to push existing data to the right or organize your layout in a specific way.

If I insert a column, do my formulas break?

No. Formulas update automatically when you insert a column. If a formula referenced column C and you insert a new column between B and C, the formula now references column D instead. You do not have to fix anything.

Can I add a column on my phone or tablet?

Yes. Open the sheet in the Google Sheets app, tap the column letter to select it, tap the three-dot menu, and choose Insert column left or Insert column right. The process is the same as on a computer, just with touch controls instead of a mouse.