fbpx

Win $2,000 by Conquering the Ultimate Google Sheets Escape Room. Play the Escape Room

Blog /

How to Insert Multiple Rows in Google Sheets

By Kathryn Rossi

Read the following guide to learn how to insert multiple rows in Google Sheets quickly and easily.

Inserting one or more rows in Google Sheets is fairly straightforward. However, adding many rows to various parts of your spreadsheet is often tedious and time-consuming, especially when you have a large dataset.

That’s why you need to learn the basic and advanced methods for inserting rows into Google Sheets side-by-side.

This guide will show you how to streamline the process of inserting multiple rows in Google Sheets, based on examples, walkthroughs, and tips.

How to Insert Multiple Rows in Google Sheets: All the Top Methods

Before showing how to insert multiple rows in Google Sheets, let’s learn how to insert a single row above or below existing rows in your spreadsheet.

First, let’s acquire a sample dataset. For this example, let’s import real-time Salesforce data into Google Sheets using Coefficient.

Read our How to Connect Salesforce to Google Sheets blog for a full walkthrough of the process.

Live Salesforce data pulled into Google Sheets

Now we have a dataset to work with, so back to our main topic. There are two ways to insert a single row in Google Sheets.

The first method is to use the Insert tab. To start, click the row header to select the entire 5th row.

Selecting a row header in Google Sheets.

Now click the Insert tab on the top menu of Google Sheets. Select Rows from the drop-down menu and Insert 1 row above.

Insert one row above in Google Sheets.

This inserts one blank row above the 5th row. Your selected row is now the 6th row, as shown below.

Insert one row below Google Sheets.

You can follow the same steps to insert one row below your selected row. Simply choose Insert 1 row below.

The second method to insert a row is the right-click menu option.

Right-click on a row. Click Insert 1 row above or Insert 1 row below to add a row.

Inserting a row in Google Sheets using Insert.

Now that you know the basics of inserting a single row, let’s learn how to insert multiple rows into Google Sheets.

1.  The Insert Menu

In this example, let’s add four rows above the 5th row. We’ll use the dataset from the previous example.

Insert multiple rows Google Sheets insert menu

To do this, select four row headers, starting from the 5th row (rows five to eight).

Select number of rows to insert.

Click the Insert menu tab, then Rows. Google Sheets automatically detects that you want to add the same number of rows.

Click Insert 4 rows above.

Untitled
Inserting multiple rows above row.

Inserting more than one row this way adds the same number of blank rows as the number of rows you’ve selected.

Select rows to insert in spreadsheet.

The original rows five to eight now appear in rows nine to twelve.

Inserting rows in Google Sheets insert menu.

Follow the same steps but choose Insert four rows below to add multiple blank rows below your selected rows.

Over 60K pros building reports use Coefficient to automate business systems data into their Google Sheets
"What an amazing app! Coefficient makes integrating some of the most complex systems unbelievably simple! Set up your integrations in less than a minute."
Yonatan Schvimer

As another option, you can also copy four blank rows and paste them between your desired rows.

2. The Right Click Menu

Another way to insert multiple rows in Google Sheets is to use the right-click menu.

Let’s leverage the same dataset from the previous example to insert four rows below row five.

Select header rows five to eight. Hold down the Shift key to select each row.

Right-click the highlighted rows to display the menu below:

Inserting rows with right click in Google Sheets.

Select Insert 4 rows below. Google Sheets will add four blank rows below your selection.

Insert new rows Google Sheets

The right-click menu offers a faster way to insert multiple rows in Google Sheets than the Insert menu tab.

3. The Keyboard Shortcut

The F4 key makes it easier to insert multiple rows into non-contiguous rows.

For instance, instead of selecting rows four, seven, and nine and individually adding rows above each one, you can simply use the F4 keyboard shortcut.

While using the F4 key won’t insert the new rows simultaneously, it can speed up the process with these steps:

  • Click row header four and insert a row above using the Insert menu tab.
F4 insert rows
  • Click row seven and hit the F4 key to instantly insert a new row above. Do the same with row nine.
Insert non contiguous rows Google Sheets

You can use the same shortcut key (F4) on Mac to insert new rows. The F4 key repeats your last action (in this case, inserting a new row above your selected row), creating a shortcut to add a new row.

That’s how you can insert multiple rows into non-contiguous rows quickly with a keyboard shortcut. This method is much faster than manually selecting each row and adding new ones above.

4. The Macros Feature

The Google Sheets macros feature can function like the F4 key. However, while F4 only saves your last action in Google Sheets, macros allow you to record and repeat a broader set of actions.

Here’s how to leverage macros to insert multiple rows in Google Sheets:

  • Go to Extensions on the Google Sheets menu and click Macros > Record Macro.
Record macro Google Sheets

A dialog box will appear on your screen to show that you’re recording a new macro.

Absolute reference macro Google Sheets

If you add rows, macros will record the action. For instance, let’s add five rows above the ninth row and click Save on the dialog box.

Save macro Google Sheets

Now name your recording. You can also create a shortcut for your recorded action by assigning a number. Click the Save button when you’re done.

Add rows macro Google Sheets

You can launch your macro from the Extensions top menu. Hover your mouse over Macros on the drop-down list and select your recorded action.

Extensions macros Google Sheets

Click Continue and follow the prompts to authorize the macro script.

Running script in Google Sheets.

After authorizing the script, return to the Extensions menu tab and click the macro to execute it. When the script is complete, you will see a “Finished script” notification, meaning the macro has executed the recorded actions.

In this example, five more rows were added to the spreadsheet. Using macros can make it easier to add multiple rows in bulk.

5. Additional Method: Insert Multiple Rows at the Bottom of Google Sheets

Google Sheets provides 1,000 rows by default. You can easily add more rows to the bottom of your spreadsheet by doing the following:

  • Press ctrl+down arrow on Windows (cmd+down arrow on Mac) to navigate to the bottom row of your spreadsheet.
  • Press the down arrow again to display the option to add more rows.
Add rows bottom Google Sheets

Add as many rows as you want (up to five million rows). Let’s add 100 more rows and click Add.

Add row to bottom of spreadsheet Google Sheets

The additional rows are added to the bottom of your spreadsheet instantly. It’s one of the simplest ways to expand the number of rows in your spreadsheet, especially for large datasets.

How to Delete and Clear Rows in Google Sheets

The spreadsheet giveth, and the spreadsheet taketh away. Inserting rows in Google Sheets is easy, and so is deleting them. Here’s how to remove rows efficiently.

Select the rows you want to remove. Then right-click on your mouse and select the delete option.

For example, let’s say you want to remove the ten blank rows (nine to eighteen) in the table below.

Add multiple rows to google sheets

Select the rows and right-click. Click Delete rows 9 – 18 to remove the select rows.

Delete rows in google sheets

If you only want to remove the values or content within your rows without deleting them, select Clear rows 9 – 18.

Inserting Multiple Rows in Google Sheets: Choose a Method, and Learn Shortcuts

Inserting multiple rows into Google Sheets isn’t difficult. But you need to know the best methods and shortcuts to streamline your spreadsheet workflows. That’s why the methods outlined in this guide come in handy. They work as one off solutions, but they can also help eliminate manual spreadsheet tasks.

And now you can make your work even more efficient by automatically importing real-time data into Google Sheets with Coefficient. Try Coefficient for free now to build live dashboards and reports in Google Sheets based on your business data.

Wait, there's more!

Connect any system to Google Sheets in just seconds.

Get Started Free
60,000+ users on
Google Marketplace
Trusted by thousands
of companies