How to Quickly Insert Multiple Rows in Google Sheets

What do you do when you want to insert multiple rows in Google Sheets?

Do you insert one row at a time?

While this can be a valid way to do this, it is time-consuming and inefficient.

Let me show you a faster way to insert multiple rows in Google Sheets.

Suppose you have a dataset as shown below and you want to insert 5 rows between row number 5 and 6.

Here are the steps to insert multiple rows in Google Sheets:

  • Select 5 rows starting from row number 6.Select rows where you want to insert multiple rows in Google Sheets
  • Right-click on any of the selected row number
  • Select ‘Insert 5 above’ option.Select insert rows above to insert multiple rows in Google Sheets

This would instantly insert 5 blank rows between rows #5 and row #6.

5 new rows inserted in Google Sheets

Note that you can also select rows 1-5 and then right click and select the option ‘Insert 5 below’.

This technique works well when you have to insert multiple rows between two rows. However, if you need to get this done for many rows (for example, insert 5 rows between all the rows, you will still need to do this one set at a time).

Again, this is one area where Excel has the upper edge as you can insert multiple rows in Excel for many numbers of rows at one go. For example, in Excel, you can insert five rows between row #5 and #6, rows #7 and #8, row #10 and #11 at one go. However, in Google Sheets, you will have to do this one by one.

You May Also Like the Following Google Sheets Tutorials:


10 Google Sheets Tips that will save you hours every week

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 4.50 out of 5)
Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.

  • >