The fastest way to add a row

Right-click on the row number where you want the new row to appear, then click Insert 1 above or Insert 1 below. Google Sheets will create a blank row at that spot and shift everything else down. This takes three seconds and works whether you have 10 rows or 10,000.

If you need to add multiple rows at once, select several row numbers first by clicking one, holding Shift, and clicking another. Then right-click and choose Insert [number] above or Insert [number] below. Google Sheets will add that many blank rows in one action.

The row numbers appear on the left side of your sheet in a gray column. Click the number itself, not the cells in that row — this selects the entire row and makes the right-click menu appear.

Key Takeaways

  • Right-click a row number on the left side of the sheet and select Insert above or Insert below to add a single row in seconds.
  • Select multiple row numbers by clicking one, holding Shift, and clicking another, then right-click to add several rows at once.
  • New rows are always blank, and existing data shifts down automatically — you will not overwrite anything.
  • You can also use the menu: click Insert at the top, then choose Rows above or Rows below.

Using the Insert menu instead of right-click

If right-clicking does not feel natural to you, the menu method works just as well. Click on a row number to select the entire row, then click Insert at the top of the sheet. A dropdown menu appears with options for Rows above and Rows below. Click whichever you need.

This route takes one extra click but gives you the same result. Some people find it easier to remember because the menu is always visible at the top of the screen.

Adding a row at the very end of your data

If you just need to add a row after all your existing data, you do not have to insert anything. Click the first empty cell below your last row of data and start typing. Google Sheets treats any cell you type into as part of your sheet, so new rows appear automatically as you add information.

This is the fastest method when you are building a sheet from scratch or adding data to the bottom. You only need to insert rows when you want to put new information in the middle of existing data.

What happens to formulas and formatting when you add a row

When you insert a row, Google Sheets shifts everything down but does not automatically copy formulas from the rows above or below. If you have a column with formulas (like a total or a calculation), you will need to add the formula to the new row yourself or copy it from an adjacent row.

Formatting like colors, fonts, and borders also does not copy to the new blank row. If your sheet has a specific look — colored headers, bold text, borders between sections — you may need to apply the same formatting to the new row to keep things consistent. The fastest way is to click a formatted cell, copy it, select the new row, and paste.

Undoing a mistake if you add a row in the wrong place

If you insert a row and realize it was the wrong spot, press Ctrl+Z on Windows or Command+Z on Mac to undo. Google Sheets will remove the row and put everything back where it was. You can undo multiple times if you need to go back several steps.

Undo works for about 30 days in Google Sheets, so you have plenty of time to catch mistakes. If you accidentally delete a row instead of inserting one, the same undo shortcut will bring it back.

Adding rows on a shared sheet

When you add a row to a sheet that other people are also editing, Google Sheets updates for everyone in real time. They will see the new row appear on their screen within a few seconds. If two people try to insert rows at the exact same spot at the same time, Google Sheets handles the conflict automatically by placing both rows and keeping all data intact.

You do not need to do anything special when working with others — just insert the row the normal way. If you are worried about stepping on someone else's work, you can check who is currently viewing the sheet by looking at the profile pictures in the top right corner of the screen.

Frequently Asked Questions

Can I add a row in the middle of a table without messing up my data?

Yes. When you insert a row, everything below it shifts down automatically. Your data stays intact — nothing gets overwritten or deleted. The new row is blank, so you can fill it with whatever you need.

What if I want to add 50 rows at once?

Select 50 row numbers by clicking the first one, holding Shift, and clicking the 50th. Then right-click and choose Insert. Google Sheets will add all 50 rows in one action. This is much faster than adding them one at a time.

Do I lose data if I insert a row by accident?

No. Inserting a row only creates blank space and shifts existing data down. Nothing is deleted. If you want to undo it, press Ctrl+Z or Command+Z to remove the row and restore the original layout.

Why did my formulas disappear when I added a row?

Formulas do not copy automatically to new rows. If you had a formula in the row above or below, you need to copy it to the new row yourself. Click the cell with the formula, copy it, click the new row's cell, and paste.

Can I add a row on my phone or tablet?

Yes, but the steps are slightly different. Open the sheet in the Google Sheets app, tap the row number to select it, tap the plus icon that appears, and choose Insert above or below. The mobile app works the same way as the desktop version.