How to Add Multiple Rows in Google Sheets

The fastest way to add multiple rows at once

To add multiple rows in Google Sheets, right-click on the row number where you want the new rows to start, then select "Insert X rows above" or "Insert X rows below" from the menu. Google Sheets will ask you how many rows you want to add, and it will insert them all at once in the location you chose.

This is faster than inserting rows one at a time, especially when you need to add ten or more rows. The rows appear empty and ready for data, and any formulas or formatting in rows below the insertion point shift down automatically.

If you want to insert rows at the very end of your sheet instead of in the middle, you can straightforward click on a cell below your current data and start typing — Google Sheets will create new rows as you work.

Key Takeaways

Right-click a row number, choose "Insert X rows above" or "Insert X rows below", and specify how many rows you need in one action.
Inserting rows in the middle of your sheet pushes existing data down and preserves any formulas that reference those rows.
You can also select multiple row numbers at once before right-clicking to insert rows in a batch without typing a number.
Adding rows at the end of your data is automatic — just click below your last row and begin typing.

Inserting rows using the row number menu

Open your Google Sheet and locate the row number on the left side where you want new rows to appear. If you want to add rows between row 5 and row 6, click on the number 6. Right-click that row number — a small menu will pop up with several options.

Look for "Insert 1 row above" or "Insert 1 row below" depending on where you want the new rows. Click on that option, and a dialog box will appear asking how many rows you want to add. Type the number — for example, type 10 if you need ten new rows — and click the "Insert" button. Google Sheets will create all those rows at once in the location you specified.

The new rows will be empty, and any data that was below the insertion point will move down. If you had formulas in those lower rows, they will automatically adjust to reference the correct rows in their new positions.

Selecting multiple rows before inserting

If you know exactly how many rows you need, you can select that many row numbers first, then insert them all at once without typing a number. Click on the first row number where you want new rows to start. Then hold down Shift and click on the row number that is as many rows down as you want to add.

For example, if you want to add five rows, click on row 10, then hold Shift and click on row 14. This selects five rows. Now right-click on one of the selected row numbers and choose "Insert 5 rows above" or "Insert 5 rows below". Google Sheets will insert exactly five new rows without asking you to type a number.

This method is useful when you can see on screen exactly how many rows you need and want to avoid the dialog box entirely.

Adding rows at the end of your data

When you want to add rows at the bottom of your sheet, you do not need to use the insert menu at all. straightforward click on a cell in the row below your last row of data and start typing. Google Sheets will automatically create new rows as you move down and to the right.

This is the simplest approach when you are building a sheet from scratch or adding a few rows to the end of an existing list. There is no menu to navigate and no dialog box to fill out — you just work, and the rows appear as you need them.

What happens to formulas and formatting when you insert rows

When you insert rows in the middle of your sheet, any formulas in rows below the insertion point will automatically update to reference the correct rows. For example, if row 10 contains a SUM formula that adds up rows 1 through 9, and you insert five new rows at row 5, that formula will move to row 15 and will still add rows 1 through 9 — it does not include the new empty rows you just created.

Formatting like colors, fonts, and borders does not automatically copy to new rows. The new rows will be blank and plain. If you want the new rows to match the formatting of surrounding rows, you can select the new rows, then use the Format menu to explore the same colors and styles.

If you have a header row at the top of your sheet, it will stay in place when you insert rows below it. The header row does not shift down — only the rows you insert and the rows below them move.

Inserting rows when your sheet is sorted or filtered

If your sheet is currently sorted by a column or filtered to show only certain rows, inserting new rows can be confusing because the new rows might not appear where you expect them. Before you insert rows, remove any sort or filter by clicking on Data in the menu, then clicking "Remove all sorts" or "Remove all filters".

Once the sort or filter is gone, your rows will return to their original order, and you can insert new rows in the location you actually want. After you finish inserting, you can reapply the sort or filter if you need it.

This extra step prevents you from accidentally inserting rows in the wrong place or creating confusion about where your data went.

Undoing a row insertion if you make a mistake

If you insert rows and then realize you made a mistake, press Ctrl+Z on Windows or Cmd+Z on Mac to undo the insertion. This will remove the rows you just added and restore your sheet to the state it was in before you inserted them. You can undo multiple times if you need to go back several steps.

If you have already done other work after inserting the rows, undoing will also undo that work, so use this feature right away if you notice the mistake. If you wait too long or do other things in the sheet, you may not be able to undo the insertion without losing other changes.

Frequently Asked Questions

Can I insert rows in the middle of a table without breaking formulas?

Yes. Formulas in rows below the insertion point will automatically update to reference the correct rows. Formulas that reference a specific range, like SUM(A1:A10), will not include the new empty rows unless you manually edit the formula to include them.

What is the difference between inserting rows above and below?

Inserting rows above means the new rows appear at the row number you selected, and everything below shifts down. Inserting rows below means the new rows appear below the row you selected. Choose based on where you want the new rows to sit relative to your existing data.

Do I lose data when I insert rows?

No. Inserting rows pushes your existing data down but does not delete anything. All your data moves to new row numbers, and formulas adjust automatically. If you want to remove rows instead, you would right-click and select "Delete rows".

Can I insert rows on a shared Google Sheet?

Yes, but other people editing the sheet at the same time may see the rows appear in a different order than you do, depending on network timing. If you are working with others, it is best to take turns inserting rows or communicate before making large changes.

What if I insert rows but they do not appear where I expected?

Check whether your sheet is sorted or filtered. If it is, the new rows may be hidden or sorted to a different location. Remove the sort or filter to see all rows in their original order, then reapply the sort or filter if needed.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.