The fastest way to add a column

Right-click on the column letter where you want the new column to appear, then click Insert 1 left or Insert 1 right. Google Sheets will create a blank column and shift the existing columns over. This takes three seconds and works whether you have 10 rows or 10,000.

If you want to add multiple columns at once, select several column letters first (click one, then hold Shift and click another), right-click, and choose Insert [number] left or Insert [number] right. Google Sheets will add that many columns in one action.

You can also add a column at the very end of your sheet by clicking on the first empty column letter and typing into it. Google Sheets treats any cell you click on as part of your sheet, so there is no separate "add column" step needed for the rightmost edge.

Key Takeaways

  • Right-click a column letter and select Insert left or Insert right to add a single column in seconds.
  • Select multiple column letters before right-clicking to add several columns at the same time.
  • Existing data shifts automatically when you insert a column, so you will not overwrite anything.
  • You can add a column at the end of your sheet by straightforward clicking on the first empty column and typing.

Adding a column between existing data

When you insert a column between columns that already have data, Google Sheets moves everything to the right. If column B contains customer names and you insert a column between A and B, the names stay in column B — they do not move to column C. Instead, your new empty column becomes the new B, and the names shift to C.

This matters because any formulas that reference column B by name will now reference the new column instead. If you had a formula in column D that said =SUM(B:B), it will now sum your new empty column instead of the names. You may need to update those formulas after inserting the column, or use column letters that will not change (like absolute references) when you build formulas.

Using the menu instead of right-clicking

If right-clicking does not work on your device or you prefer the menu, click Insert at the top of the sheet, then choose Columns left or Columns right. This adds one column to the left or right of whichever column you have selected. You must click on a column letter or a cell in that column first, or Google Sheets will not know where to insert.

The menu route takes one extra step but works the same way as right-clicking. Some people find it easier on a touchpad or when using accessibility tools.

Deleting a column you added by mistake

Right-click the column letter and select Delete column. The column disappears and everything to the right shifts left. If you deleted the wrong column, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo.

Google Sheets keeps an undo history, so you can undo multiple actions in a row if you need to. The undo button is in the top left corner, or you can use the keyboard shortcut.

Moving a column instead of adding one

If you want to rearrange columns rather than add a new one, click on the column letter to select the entire column, then drag it to a new position. A blue line appears between columns to show where it will land. Release the mouse to drop it there.

Moving is different from inserting: you are changing the order of existing columns, not creating a new one. This is useful when you realize your data would be easier to read in a different order, but it does not add any columns to your sheet.

Adding a column with a header and formatting

After you insert a blank column, click on the first cell (usually the header row) and type a name for that column. Then format it to match your other headers: select the cell, click the paint bucket icon in the toolbar, and choose a background color that matches. You can also make the text bold by selecting the cell and clicking the bold button.

If your sheet has many columns with the same formatting, copying the header cell from an existing column and pasting it into your new column will copy the formatting too. Click the header you want to copy, press Ctrl+C (or Cmd+C), click your new header cell, and press Ctrl+V to paste.

Frequently Asked Questions

What happens to my formulas when I insert a column?

Formulas that reference columns by letter (like =SUM(B:B)) will now reference the new column in that position. Formulas that reference specific cells (like =A1+A2) will shift their references to the right if the column they point to moves. If you want a formula to stay fixed on a certain column no matter what, use an absolute reference like =$B$1 instead of B1.

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

Yes. Click on the column A letter, right-click, and select Insert 1 left. Your new column becomes the new A, and everything shifts right. This is useful if you want to add an ID column or row numbers at the very start of your sheet.

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

Right-click the column letter where you want the new column to appear and select Insert left or Insert right. Google Sheets will create the new column and shift all existing data to the right automatically. Nothing is deleted or overwritten.

Can I add multiple columns at different places in my sheet?

You can add multiple columns in one action only if they are next to each other. Select the column letters where you want them to appear (for example, click C, hold Shift, click E), right-click, and choose Insert. Google Sheets will add three columns in that space. To add columns in separate locations, insert them one at a time.