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.
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.
Now click the Insert tab on the top menu of Google Sheets. Select Rows from the drop-down menu and Insert 1 row above.
This inserts one blank row above the 5th row. Your selected row is now the 6th row, as shown below.
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.
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.
To do this, select four row headers, starting from the 5th row (rows five to eight).
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.
Inserting more than one row this way adds the same number of blank rows as the number of rows you’ve selected.
The original rows five to eight now appear in rows nine to twelve.
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
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:
Select Insert 4 rows below. Google Sheets will add four blank rows below your selection.
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.
- Click row seven and hit the F4 key to instantly insert a new row above. Do the same with row nine.
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.
A dialog box will appear on your screen to show that you’re recording a new macro.
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.
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.
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.
Click Continue and follow the prompts to authorize the macro script.
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 as many rows as you want (up to five million rows). Let’s add 100 more rows and click Add.
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.
Select the rows and right-click. Click Delete rows 9 – 18 to remove the select rows.
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.