How to Insert More Than One Row in Google Sheets: A Step-by-Step Guide

Adding multiple rows to your Google Sheets can seem like a daunting task, but it’s actually quite simple! In just a few clicks, you can insert as many rows as you need, whether it’s two or twenty. The process is straightforward, and once you get the hang of it, you’ll be able to do it in no time. So, let’s get started!

Step by Step Tutorial: Inserting Multiple Rows in Google Sheets

Before we get into the nitty-gritty of adding rows, let’s understand what we’re aiming for. By following these steps, you’ll be able to insert multiple blank rows into your Google Sheets document, which can be helpful for organizing data, adding new information, or making your sheet easier to read.

Step 1: Select the row below where you want to insert new rows

Click on the row number to the left of the sheet to select the entire row.

Selecting the row below where you want to insert new rows is crucial because Google Sheets inserts new rows above the selected row. So, if you want to add rows between rows 10 and 11, you’ll need to click on row 11.

Step 2: Right-click to open the context menu

After selecting the row, right-click to bring up a menu of options.

This context menu is where you’ll find the option to insert rows. It’s also where you can find other useful tools for editing your sheet, like deleting rows or copying them.

Step 3: Choose ‘Insert x rows above’ or ‘Insert x rows below’

From the menu, select the number of rows you wish to add and whether you want them above or below your selected row.

The ‘x’ in ‘Insert x rows’ represents the number of rows you want to add. If you want to insert more than one, Google Sheets will give you the option to insert a specific number of rows in one go.

Step 4: Repeat the process if you need to add more rows

If you need to add a large number of rows, you can repeat steps 1-3 until you have the desired number of rows.

It’s as simple as that! Once you’ve added all your rows, you can start filling them with data, or leave them blank until you need them.

After completing these steps, you’ll see the new rows appear in your sheet. They will be completely blank, ready for you to fill with data. The existing data in your sheet will be pushed down or up, depending on where you inserted the new rows.

Tips: Making the Most of Multiple Rows in Google Sheets

  • To quickly select multiple rows, click on the first row number, then hold down the ‘Shift’ key and click on the last row number.
  • If you need to insert the same number of rows multiple times, use the ‘Ctrl’ + ‘Y’ shortcut to repeat the last action.
  • To insert rows at the bottom of your sheet, scroll down and hover your mouse over the bottom left corner until you see a blue line, then click to add a row.
  • Use the ‘Ctrl’ + ‘C’ and ‘Ctrl’ + ‘V’ shortcuts to copy and paste data into your new rows quickly.
  • If you accidentally insert too many rows, you can easily delete them by selecting the rows, right-clicking, and choosing ‘Delete rows’.

Frequently Asked Questions

Can I undo adding rows?

Yes, you can undo the insertion of rows by using the ‘Ctrl’ + ‘Z’ shortcut or by clicking the ‘Undo’ button in the toolbar.

Can I add rows on the Google Sheets mobile app?

Yes, you can add rows in the Google Sheets mobile app by tapping on a row number, selecting ‘Insert row above’ or ‘Insert row below’ from the menu that appears.

Is there a limit to the number of rows I can insert at one time?

While Google Sheets doesn’t impose a strict limit on the number of rows you can insert at once, inserting a very large number of rows may slow down your sheet.

How do I add multiple rows at the end of my sheet?

To add multiple rows at the end of your sheet, select the last row and use the context menu to insert rows above or below, depending on your preference.

Can I insert rows between two existing rows of data?

Yes, you can insert rows between two existing rows by selecting the row below where you want the new rows and then following the steps outlined in the tutorial.


  1. Select the row below where you want to insert new rows.
  2. Right-click to open the context menu.
  3. Choose ‘Insert x rows above’ or ‘Insert x rows below’.
  4. Repeat the process for additional rows.


Inserting more than one row in Google Sheets is a piece of cake once you know how to do it. Whether you’re organizing data, making room for new information, or simply trying to make your spreadsheet look cleaner, these steps will help you achieve your goal efficiently. Remember to use the handy tips provided to streamline the process even further. Don’t let the fear of messing up your data hold you back; with the ability to undo actions and the flexibility of Google Sheets, you’re always in control. So go ahead, give it a try and see how easy it is to customize your sheets to fit your needs.