Google Sheets

How to Add Columns or Rows in Google Sheets

Deborah Tennen Avatar
Written by Deborah Tennen
Last updated May 13, 2019

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

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.

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.

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

Related Reading

Related Tutorials

How to Filter in Google Sheets

Justin Pot Avatar

Justin Pot

How to Import Data into Google Sheets

Justin Pot Avatar

Justin Pot

How to Download Your Data from Google Sheets

Justin Pot Avatar

Justin Pot

Getting Started with Zapier