How to add a row in google sheets on a mac

• You can insert multiple rows in Google Sheets, either above or below your existing rows.
• When you're working with a spreadsheet in Google Sheets, you can add rows with just a couple of clicks.
• Visit Business Insider's homepage for more stories.

If you need to add data to the middle of a Google Sheet, you could add it at the bottom, and then re-sort your sheet to get the new entries to the right place — but it's sometimes easier to simply add new rows in the spot where you want to place the data.

Here's how to do it.

Check out the products mentioned in this article:

MacBook Pro (From $1,099.99)

Lenovo IdeaPad 130 (From $299.99)

How to insert a single row in Google Sheets

When you select a cell in Google Sheets, you can right click to add a new row.

1. Right-click on a selected cell.

2. Choose "Insert Row" from the pop-up menu.

Your row will be added above the cell you selected.

Notice that you don't have the option to insert multiple rows or to insert rows below the current row. Read on for instructions on how to insert more than one row.

How to insert multiple rows in Google Sheets

It's simple to have more control over adding rows, if you know what to do. Here are the steps to add multiple rows in Google Sheets at once. 

1. Click and hold your mouse on the number to the left of the row where you want to add more rows. This will highlight the whole row. 

2. Without releasing that click, drag your cursor down to highlight the number of rows you want to add. For example, if you want to add two rows, drag over the next row down to highlight two rows.

3. Right-click anywhere in the highlighted area. Click "Add [number] Rows" in the menu that appears. You'll have two options — to add rows above or below your current row.

Your new rows will appear immediately.

Related coverage from How To Do Everything: Tech:

• How to add a drop-down list in Google Sheets to group and organize data in your spreadsheet

• How to set a print area in Google Sheets, so you can print selected cells or sheets

• How to edit Google Docs files offline, for when you're without internet or trying to eliminate online distractions

• How to remove a credit card from Google Play on your Android phone

• 'What is Google Authenticator?': How to set up Google's two-step verification software to secure all of your Google apps

Laura McCamy is a freelance writer based in the San Francisco Bay Area.

Read more Read less

This wikiHow teaches you how to add a column to a spreadsheet using Google Sheets on your computer.

Steps

1. 

   1

   Go to https://sheets.google.com in a web browser. This will bring up a list of spreadsheets you’ve worked on recently.

   • If you’re not already signed in to your Google account, you’ll be prompted to do so now.

2. 

   2

   Open the spreadsheet you want to edit. There are three ways to do this:

   • If the file is already in your Google Drive, you'll see it in the file list. Click its name to open it in Sheets.
   • If it's is on your computer, click the gray folder at the top-right corner of the file list, click Upload, then click Select a file from your computer. Double-click the file you want to edit, then click Open.
   • To create a new spreadsheet, click the box with an "+" at the top-left corner of Sheets, then add your data.

3. 

   3

   Right-click the letter above a column. Choose the column either before or after where you want to insert a new column. A menu will appear.

4. 

   4

   Click Insert 1 left or Insert 1 right. The option you select depends on where you want the new column to go. The new column will appear to the left or right of the current column.

   • Choose Insert 1 left to create a new blank column to the left of the selected column.
   • Choose Insert 1 right to create a new blank column to the right of the selected column.

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

About this article

Article SummaryX

1. Open Google Sheets.
2. Open a spreadsheet.
3. Right-click a column header.
4. Click Insert 1 left or Insert 1 right.

Did this summary help you?

Thanks to all authors for creating a page that has been read 3,859 times.

Is this article up to date?

How do I insert a row in Google Sheets?

How do you insert multiple rows in Google Sheets on a Mac?

How do I add a new row in Mac?

How do you add cells in Google Sheets Mac?

Is there a shortcut to insert a row in Google Sheets?

How do you add a row in Google Sheets iOS?