How To Insert Multiple Rows In Google Sheets

Google Sheets is a powerful tool for organizing and manipulating data. When working with a substantial amount of data, you might need to insert multiple rows at once. It might seem daunting at first, but with a few easy steps, you will learn how to add multiple rows in Google Sheets effortlessly.

Method 1: Using the Interface

The first method involves using the Google Sheets interface. Here’s how:

  1. Open your Google Sheets document.
  2. Click and drag to highlight the number of rows you want to insert.
  3. Right-click on the highlighted rows.
  4. Select “Insert X above” or “Insert X below” where X is the number of rows you have highlighted.

While this method is straightforward, it can be a bit time-consuming if you need to insert many rows.

Method 2: Using Google Apps Script

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. You can use it to automate the process of adding multiple rows in Google Sheets. Let’s see how it’s done:

function insertRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var numberOfRow = 10; // Put the number of rows you want to add here
  sheet.insertRowsAfter(sheet.getLastRow(), numberOfRow);

In the above code, you should replace ’10’ in the variable numberOfRow with the number of rows you want to add. When you run this script, it will add the specified number of rows at the bottom of your active sheet.

For this to work, you need to have the necessary permissions to run Google Apps Scripts. Also, remember that this will add rows to the active sheet, so make sure you have the correct sheet selected before running the script.


Adding multiple rows in Google Sheets can be done either manually via the interface or more efficiently using Google Apps Script. Depending on your preference and requirement, you can use either of these methods. Knowing how to perform this task is an essential part of mastering Google Sheets, especially when managing large datasets.