How To Quickly Add Rows In Google Sheets

Google Sheets is a popular online spreadsheet application that offers a host of features to manage and manipulate data. One of the common tasks you’ll often encounter when working with Google Sheets is adding new rows. This blog post will guide you through the steps on how to quickly add rows in Google Sheets.

Manually adding new rows in Google Sheets:

Manually adding a new row in Google Sheets is quite straightforward and can be done by following these steps:

  1. Open your Google Sheets document.
  2. Click on the row header (the numbered gray box at the left of the row) to select the entire row.
  3. Right-click on the row header and select ‘Insert 1 above’ or ‘Insert 1 below’, depending on where you want to insert the new row.

This is convenient for adding a few rows, but if you’re dealing with dozens or even hundreds, it can become laborious.

Adding multiple rows in Google Sheets:

If you need to add multiple rows at a time, Google Sheets provides an efficient way to do this:

  1. Select the number of rows you want to add. For example, if you want to add five rows, select five existing rows.
  2. Right-click on the selected rows and choose ‘Insert x above’ or ‘Insert x below’, where x is the number of rows you initially selected.

The above method will add the exact number of new rows you need in just a few clicks.

Adding rows using Google Apps Script:

For those who want to automate the process of adding new rows, you can use Google Apps Script. Here’s a simple example:

function addRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.insertRowsAfter(1, 5);

In this script, ‘1’ refers to the row after which new rows will be added and ‘5’ is the number of new rows to add.


While it may seem daunting at first, adding new rows in Google Sheets is a breeze once you know how to do it. Whether you’re manually adding rows, adding multiple rows at once, or automating the process with Google Apps Script, this guide has you covered. Happy spreadsheeting!