Sign up
  • Home
  • Productivity
  • App tutorials

How to Add Columns or Rows in Google Sheets

App tutorials

2 min read

How to Add Columns or Rows in Google Sheets

By Deborah Tennen · May 14, 2019
how-to-add-columns-rows-google primary img

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

How to Add columns in Google Sheets

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

Step 2: Click Insert in the toolbar.

Click Insert

Step 2: Select either Column left or Column right. Column left will insert a column to the left of the column you're currently clicked into. Column right will insert one to the right.

Column left or Column right

After clicking, the new column will appear.

New column

How to add columns in Google Sheets using right-click

Make your Google Sheets work for you
Automate Google Sheets

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

Step 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

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

alt

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. 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

How to Add Rows in Google Sheets

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

Step 2: Click Insert in the toolbar.

Click Insert

Step 2: Select either Row above or Row below. Row above will insert a row directly above the column you're currently clicked into. Row below will insert one directly below.

Row above or Row below

After clicking, the new row will appear.

New row

How to add rows 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.

Step 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.

Select entire row

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

alt

How to add multiple rows in Google Sheets

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. If you want to add ten rows, highlight the ten rows above or below the rows you want to add. And so on.

Add multiple columns

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.

Related Reading

Get productivity tips delivered straight to your inbox

We’ll email you 1/wk, and never share your information.

Deborah Tennen picture

Deborah Tennen

Deb Tennen is managing editor of the Zapier blog. When she’s not working, Deb is either watching television or showing someone a picture of her dog.

mentioned apps

Related articles

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

Sign upSee how it works