The fastest way to add a row
Right-click on the row number on the left side of the spreadsheet where you want the new row to appear. A menu will pop up. Click "Insert 1 above" to add a row above that row, or "Insert 1 below" to add one below it. Google Sheets will shift everything down or up automatically, and your new empty row is ready to fill in.
This method works whether you have 10 rows or 10,000 rows. The row number you click on determines where the new row lands — if you right-click on row 5, the new row becomes row 5 and everything that was row 5 moves down to row 6.
If you need to add multiple rows at once, right-click on a row number, then hold Shift and click on another row number a few rows down. This selects a range. Right-click again and choose "Insert [number] above" or "Insert [number] below" — Google Sheets will add as many rows as you selected.
Key Takeaways
- Right-click any row number and select "Insert 1 above" or "Insert 1 below" to add a single row in seconds.
- Select multiple row numbers by clicking one, holding Shift, and clicking another to add several rows at once.
- The row number you click on determines where the new row appears — clicking row 5 inserts above or below row 5.
- Google Sheets automatically shifts existing data down or up, so you never lose information when adding rows.
Adding rows using the menu bar
If you prefer using the menu instead of right-clicking, click on any cell in the row where you want to insert a new one. Then go to the menu at the top and click "Insert," followed by "Rows above" or "Rows below." This does exactly the same thing as right-clicking, just through a different path.
The menu method is useful if right-clicking feels awkward on your device or if you are using a trackpad that makes right-clicking difficult. The result is identical either way.
Adding a row at the very end of your data
If you want to add a row after all your existing data, you do not need to insert anything. straightforward click on the first empty cell below your last row of data and start typing. Google Sheets will treat it as a new row automatically.
This is the fastest approach when you are adding data sequentially — for example, if you are building a list and want to add the next item. You only need to use the insert method when you want the new row to go in the middle of existing data.
Inserting rows in a specific location
Sometimes you need a new row between two rows that already have data. Click on the row number of the row that will come after your new row. For example, if you want to insert between rows 7 and 8, click on row 8. Right-click and select "Insert 1 above." Your new row becomes row 8, and what was row 8 moves down to row 9.
This matters because it is straightforward to get backwards. The row you click on is the one that moves down. If you click on row 7 and choose "Insert 1 below," you get the same result — a new row between the old rows 7 and 8 — but thinking about it as "insert below row 7" is often clearer than thinking about which row number to click.
What happens to formulas and formatting when you add rows
If your spreadsheet has formulas — like a column that adds up numbers or calculates a percentage — Google Sheets usually adjusts them automatically when you insert a row. A formula that was summing rows 2 through 10 will adjust to sum rows 2 through 11 if you insert a new row in the middle.
Formatting like bold text, colors, or cell borders does not automatically copy to the new row. If you have a row with a light blue background and you insert a row above it, the new row will be plain white. You can copy the formatting from a nearby row by selecting that row, copying it, then right-clicking the new row and choosing "Paste special" and then "Formatting only."
Undoing a row you added by mistake
If you insert a row and when ready realize you did not want to, press Ctrl+Z on Windows or Command+Z on Mac. Google Sheets will undo the insertion and restore whatever was there before. This works as long as you have not made other changes since the insertion.
If you inserted a row several actions ago and want to undo it now, you can still press Ctrl+Z or Command+Z multiple times to step backwards through your recent actions. Google Sheets shows you what it is undoing as you go, so you can stop when you reach the point you want.
Adding rows on mobile devices
On a phone or tablet, open your spreadsheet in the Google Sheets app. Tap and hold on the row number you want to insert next to. A menu will appear with options to insert above or below. Tap your choice, and the row appears.
The mobile app works the same way as the desktop version — you select a row by its number, then choose where the new row should go. If you find the small row numbers hard to tap, you can also click on any cell in that row, then use the menu (three horizontal lines at the top) to find the insert option.
Frequently Asked Questions
Can I add multiple rows at different places in my spreadsheet at once?
No, you have to add rows one location at a time. However, you can add several rows in the same location at once by selecting multiple consecutive row numbers before inserting. If you need rows in three different spots, you will insert three separate times.
What if I insert a row and my data shifts in a way I did not expect?
Press Ctrl+Z or Command+Z when ready to undo. Then try again, making sure you clicked on the row number where you want the new row to appear. Remember: the row you click on is the one that moves down when you choose "Insert above."
Does adding a row cost anything or use up my storage?
No. Google Sheets stores your entire spreadsheet as one file, and adding rows does not change how much storage it uses in any meaningful way. You can add thousands of rows without any cost or storage penalty.
Can I add a row to a shared spreadsheet that other people are editing?
Yes. When you insert a row, Google Sheets updates it for everyone viewing the sheet in real time. If someone else is editing nearby, you might see a notification that the sheet has changed, but the insertion will not interfere with their work.