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 everything else over. That's the whole process — you don't need to select anything first, and you don't need to name the column unless you want to.

If you need to add multiple columns at once, select the number of columns you want by clicking on one column letter, then holding Shift and clicking on another. Right-click and choose Insert [number] left or Insert [number] right. Google Sheets will add that many blank columns in one action.

You can also add a column by clicking the plus icon that appears when you hover over the rightmost column header. This always adds a column to the right of everything else, which is useful if you're building a spreadsheet from scratch and just want to keep extending it.

Key Takeaways

  • Right-click any column letter and choose Insert left or Insert right to add a single column wherever you need it.
  • Select multiple column letters at once before right-clicking if you need to add several columns in the same spot.
  • The plus icon at the far right of your column headers adds a new column to the end without any menu steps.
  • New columns are always blank — Google Sheets doesn't copy formatting or formulas from nearby columns unless you do it yourself.

Where the new column appears

When you choose Insert left, the new column appears to the left of the column you right-clicked on. When you choose Insert right, it appears to the right. Everything in the columns that shift gets moved along with them — no data is deleted, and any formulas that reference those columns update automatically.

If you insert a column in the middle of data you're using in a formula, Google Sheets adjusts the formula to account for the shift. For example, if you have a formula that adds up columns A through C, and you insert a new column between A and B, the formula becomes A plus the new column plus B plus C. This usually works the way you want, but it's worth double-checking important formulas after you insert columns nearby.

Adding a column without right-clicking

Open the Insert menu at the top of the page and select Column left or Column right. This does the same thing as right-clicking, but it inserts relative to whichever column you currently have selected. If no column is selected, Google Sheets will ask you to pick one.

The menu route is slower than right-clicking, but some people find it easier to remember. It also works the same way on phones and tablets, where right-clicking isn't always reliable.

Naming and formatting your new column

New columns arrive blank, including the header row. Click on the top cell of your new column and type a name — something like "Notes" or "Date Completed" — so you and anyone else reading the sheet know what goes in that column.

If you want the new column to match the formatting of nearby columns (font, color, borders, number format), select a column that has the formatting you want, then copy it. Right-click on your new column header and choose Paste special, then Paste format only. This copies the look without copying any of the data or formulas.

Moving a column instead of adding one

If you realize you added a column in the wrong spot, you don't have to delete it and start over. Click on the column letter to select the entire column, then drag it to where you want it. Google Sheets will show you a blue line indicating where the column will land when you release the mouse.

Dragging works for moving multiple columns too — select the columns you want to move by clicking one letter, holding Shift, and clicking another, then drag the whole selection to its new home.

Removing a column you don't need

Right-click on the column letter and select Delete column. The column disappears, and everything to the right shifts left to fill the gap. Any formulas that referenced that column will show an error (usually #REF!) because the data they pointed to no longer exists.

If you delete a column by mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo. Google Sheets keeps a deletion in the undo history for several actions, so you usually have time to get it back.

Frequently Asked Questions

What happens to formulas when I insert a column?

Google Sheets automatically updates formulas to account for the new column's position. If a formula referred to columns A, B, and C, and you insert a column between A and B, the formula now includes the new column in its range. Check important formulas after inserting columns to make sure the update makes sense for what you're trying to do.

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

Yes. Click on the column A header, right-click, and choose Insert 1 left. The new column becomes column A, and what was column A shifts to become column B. This is useful if you realize you need an ID column or a name column at the very beginning of your sheet.

Does inserting a column affect my data?

No. Inserting a column only adds blank space — it doesn't delete or change any existing data. Everything shifts over to make room, and formulas update to point to the right cells. The only time data is affected is if you delete a column, which removes that column's contents permanently.

How do I add a column on my phone or tablet?

Open the sheet in the Google Sheets app, tap the column letter to select it, then tap the plus icon that appears. You can also use the Insert menu at the top. The process is the same as on a computer, just adapted for touch instead of a mouse.