How to Add a Column in Google Sheets (Computer and Phone)

You open a client spreadsheet, realise there's no space for the one detail you need, and the data is already packed edge to edge. It's a tiny job, but it trips up a lot of people because the option you want hides inside a right-click menu.

Here's how Google's own help pages say to slot a new column in, whether you're at a desk or on your phone, plus the side issues that catch small business owners out when a sheet is shared with a team.

Putting a new column into Google Sheets on a computer

According to Google's help, you start by selecting something that sits next to the spot you want, then use the right-click menu. Your selection can be a column, a row or just a cell.

1. Open your spreadsheet in Google Sheets in your browser.
2. Click the letter at the top of the column that's next to where the new one should go. (Google also lets you start from a row or a single cell.)
3. Right-click the selection.
4. Choose Insert 1 left or Insert 1 right, depending on which side you want the blank column to appear.
5. Click into the first cell of the new column and type your heading.

The menu wording is the same family as the row options, which read Insert 1 above and Insert 1 below. If you picked a single cell, you'll see all four directions listed, so choose the left or right one for a column.

Adding several columns to Google Sheets in one go

If you need three new fields for a lead tracker, you don't have to repeat the whole routine three times. Google's help describes a faster route:

1. Select as many columns as you want to add. On Windows hold Ctrl and click; on a Mac hold Cmd and click.
2. Right-click anywhere in the selection.
3. Pick the insert option that matches the number you selected, and Sheets adds that many blank columns.

Keep the count in mind. Selecting three columns and inserting gives you three new ones, so select exactly the number of blanks you want rather than the whole sheet.

Adding a column in the Google Sheets app on Android or iPhone

The mobile apps use an icon instead of a right-click. Google's help gives the same short routine for Android phones and tablets and for iPhone and iPad:

1. Open the spreadsheet in the Google Sheets app.
2. Tap a column or row to select it.
3. Tap the Insert icon.
4. Choose one of the options in the menu that appears.

Menus vary a little between app versions, so if your icon looks different, tap around the toolbar for the one that mentions insert. Editing on a small screen can be fiddly, so I'd save big restructuring jobs for a laptop.

Why a Google Sheets column insert is not the same as adding rows at the bottom

People often mix these up. Google's help has a separate tip for rows: scroll to the bottom of the sheet, type a number into the box next to the words 'more rows at the bottom' and click Add. Google describes that as the way to add 100 or more rows at once.

That box only adds rows. There's no matching box for columns, so a new column always comes from the insert menu described above.

What you want	What Google's help says to use
One blank column beside another	Right-click, then Insert 1 left or Insert 1 right
Several blank columns	Select that many with Ctrl-click or Cmd-click, then right-click and insert
Lots of blank rows	The 'more rows at the bottom' box, then Add
A new column on a phone	Select it, tap the Insert icon and choose from the menu

Adding a column in Google Sheets without wrecking your client or team data

A new column is easy. Keeping everything else tidy afterwards takes a little thought, especially when other people use the same file.

• Look at any formulas that reach across the sheet once the column is in. Click a couple and check they still point at the right cells.
• Give the new heading the same style as its neighbours so the sheet still reads as one table.
• If a colleague has the sheet open, tell them. Edits show up as you work, but a surprise column in the middle of their view can confuse them.
• Decide where the column belongs before you insert. A status or date column often works better at the far left so it's the first thing anyone sees.

Once the structure is right, you may want to put things in order. My step-by-step on sorting a Google Sheet shows how to arrange the new data once it's filled in.

Using a new Google Sheets column to keep a small business tidy

The sheets I see small business owners keep tend to grow one column at a time. A few ways a new column earns its place:

• A contact list gets a 'last spoken to' date so nobody chases the wrong lead.
• A content plan gets a status column with values like Idea, Drafted and Live.
• A supplier list gets a renewal date so nothing lapses quietly.
• A task sheet gets an owner column, which stops jobs drifting.

If the cells you're adding have long entries, wrapping text in Google Sheets makes the new column readable without stretching it across the screen.

If you can't add a column in Google Sheets

When the insert option is missing or won't respond, go through these in order:

1. Check your access. Google's Drive help says a Viewer or Commenter can't edit a file, while an Editor can. If you only have view access, ask the owner for edit access.
2. Make sure you've selected a column, row or cell first. The insert choices appear from your selection.
3. On a phone, confirm you've picked a row or column before tapping the Insert icon.
4. Refresh the page or reopen the app, then try again.
5. If it still won't work, use Google's help centre, because it can see account settings that I can't.

A shared sheet can also be protected by its owner in ways that stop edits, so a quick message to them often solves it faster than hunting through menus.

Frequently asked questions

How do I add a column in Google Sheets?

Right-click a column letter, a row or a cell next to where you want it and choose Insert 1 left or Insert 1 right. On the phone app, select a column or row, tap the Insert icon and pick an option.

Can I add several columns at once in Google Sheets?

Yes. Select multiple columns by holding Ctrl and clicking on Windows, or Cmd and clicking on a Mac, then right-click and choose the insert option that matches the number you selected.

How do I add more rows in Google Sheets?

Scroll to the bottom of the sheet, type the number into the box next to 'more rows at the bottom' and click Add. Google describes this as the way to add 100 or more rows.

How do I add a column in the Google Sheets app?

Open the spreadsheet in the app, select a row or column, tap the Insert icon and choose from the menu that appears. The steps are the same on Android and on iPhone or iPad.

Why can't I insert a column in my Google Sheet?

The most common reason is access. Viewers and Commenters can't edit a file, so ask the owner for Editor access, then select a column and try the right-click menu again.