Loading
  • Home

  • Productivity

  • App tips

App tips

3 min read

How to add columns or rows in Google Sheets

By Deb Tennen · March 21, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

Adding columns and rows in Google Sheets can be a two-click process. Open your spreadsheet, and follow along below to see how it's done.

How to add columns in Google Sheets

Here's how to add a column in Google Sheets:

  1. Click anywhere in the column that's next to where you want your new column.

  2. Click Insert in the toolbar.

  3. Click Columns, and then select either Insert 1 column left or Insert 1 column right, depending on where you want your new column.

Adding a column in Google Sheets

That's it! Your new column will appear.

How to add columns in Google Sheets using right-click

You can achieve the same effect without the toolbar by using the right-click function on your mouse or trackpad.

  1. Instead of just clicking into the column, you'll need to select the entire column next to where you want your new column. Do this by clicking the letter at the top of the column.

    Select entire column
  2. Right-click anywhere in that column, and then select either Insert 1 column left or Insert 1 column right.

    Right-clicking to add a column in Google Sheets

How to add multiple columns in Google Sheets

If you want to add multiple columns, you can follow the same process, but—whether using the toolbar or the right-click method—start by highlighting the number of columns you want to add.

For example, if you want to add two columns, highlight the two columns next to the columns you want to add. (You can do this by clicking on the letter at the top of the first column and immediately dragging across to highlight more.) If you want to add ten columns, highlight the ten columns next to the columns you want to add. And so on.

Add multiple columns in Google Sheets

How to add rows in Google Sheets

Here's how to add a row in Google Sheets:

  1. Click anywhere in the row that's either above or below where you want your new row.

  2. Click Insert in the toolbar.

  3. Click Rows, and then select either Insert 1 row above or Insert 1 row below, depending on where you want your new row.

Adding a row in Google Sheets

How to add rows in Google Sheets using right-click

Same as with columns, you can achieve the same effect with a right-click.

  1. Select the entire row above or below where you want your new row. Do this by clicking the number to the left of the row.

  2. Right-click anywhere in that row, and then select either Insert 1 row above or Insert 1 row below.

Adding a row by right-clicking in Google Sheets

How to add multiple rows in Google Sheets

Broken record time. If you want to add multiple rows, you can follow the same process, but—whether using the toolbar or the right-click method—start by highlighting the number of rows you want to add.

For example, if you want to add two rows, highlight the two rows above or below the rows you want to add. (You can do this by clicking on the letter next to the first row and immediately dragging down to highlight more.) If you want to add ten rows, highlight the ten rows above or below the rows you want to add. And so on.

Adding multiple rows in Google Sheets

If you want to add a large number of rows to the bottom of your spreadsheet, scroll all the way to the bottom and you'll see the option to add any number of rows. Type the number of rows you want, and click Add.

How to add rows and columns to Google Sheets on the mobile app

There are a few ways to add a column or row on the Google Sheets app, but here's the easiest way.

  1. Tap the number of the row or column next to where you want your new row or column.

  2. Tap the icon at the bottom-right of the screen indicating where you want the new row or column to go.

For rows, the plus signs on the top and bottom indicate where the new row will be added. For columns, the plus signs on the left and right indicate where the new row will be added.

The icons to add a column or row in Google Sheets

Automatically add rows to Google Sheets 

You can automatically add rows to Google Sheets based on activity in other apps, like Gmail, Typeform, or Shopify. Just connect Google Sheets to Zapier, and then set up your no-code workflow. Learn more about how to automate Google Sheets, or get started with one of these pre-built templates.

Save new Gmail emails matching certain traits to a Google Spreadsheet

Save new Gmail emails matching certain traits to a Google Spreadsheet
  • Gmail logo
  • Google Sheets logo
Gmail + Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets

Add new Facebook Lead Ads leads to rows on Google Sheets
  • Facebook Lead Ads logo
  • Google Sheets logo
Facebook Lead Ads + Google Sheets

Generate rows in Google Sheets for new Unbounce submissions

Generate rows in Google Sheets for new Unbounce submissions
  • Unbounce logo
  • Google Sheets logo
Unbounce + Google Sheets

Zapier is a no-code automation tool that lets you connect your apps into automated workflows, so that every person and every business can move forward at growth speed. Learn more about how it works.

Related reading:

  • How to use Google Sheets: A complete guide

  • 21 free Google Sheets templates to boost productivity

  • Why Google Sheets should be your to-do list (with template)

  • How to make a table in Google Sheets

This article was originally published in May 2019. The most recent update was in March 2024.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'