The fastest way to add rows in Excel

When your spreadsheet data reaches the bottom of your visible area, you can add new rows in three ways. The simplest is to click on a row number on the left side, right-click, and select Insert — this pushes everything below down and creates a blank row where you clicked. If you need multiple rows at once, click the first row number, hold Shift, and click the last row number you want to select, then right-click and choose Insert. Excel will add as many rows as you selected.

The second method works if you are already typing in a cell near the bottom of your data. Press Ctrl+Shift+Plus (the plus key on your keyboard, not the numpad), and Excel opens a dialog asking what you want to insert. Choose Entire row and click OK. This adds one row above wherever your cursor is.

The third method is the one most people discover by accident: click on a cell in the row below where you want to insert, then start typing. Excel automatically creates a new row beneath your data without you asking. This works for adding one row at a time but is slower if you need many rows at once.

Key Takeaways

  • Right-click a row number and select Insert to add a single row at that location, pushing all rows below it down.
  • Select multiple row numbers by clicking the first, holding Shift, and clicking the last, then right-click Insert to add that many rows all at once.
  • Press Ctrl+Shift+Plus while your cursor is in a cell to open the Insert dialog and add a row above that cell.
  • Excel automatically creates new rows when you type in a cell below your existing data, though this is slower than inserting multiple rows at once.

Selecting rows before you insert

The row number column on the left side of Excel is where you click to select entire rows. When you click a row number, the whole row highlights in blue. This is different from clicking inside a cell, which selects only that cell.

To select a single row, click its number. To select several rows in a row, click the first number, then hold Shift and click the last number — all rows between them highlight. To select rows that are not next to each other, click the first row number, then hold Ctrl and click each additional row number you want.

Once rows are selected, right-click anywhere in the highlighted area. A menu appears with options including Insert. Click it, and Excel inserts the same number of new rows as you selected, pushing your existing data down. The new rows appear above the first row you selected.

Understanding where new rows appear

This is the part that confuses most people: when you select a row and insert, the new row appears above the row you selected, not below it. If you select row 5 and insert, a new blank row becomes row 5, and your old row 5 becomes row 6.

This matters when you are trying to add rows at the bottom of your data. If your data ends at row 20 and you want to add rows after it, click on row 21 (or any row below your data) and insert. The new rows will appear above row 21, which means they land right after your data ends.

A simpler approach: just click on any cell in the row below your data and start typing. Excel creates the row automatically without you having to think about which direction things move.

Adding rows using the menu instead of right-click

If you prefer using the menu bar instead of right-clicking, you can insert rows there too. Select the row or rows where you want to insert, then click the Home tab at the top (it is usually already selected). Look for a button that says Insert — it is usually in the top-left area of the toolbar, sometimes with a small dropdown arrow next to it.

Click Insert and a menu appears with options like Insert Sheet Rows or Insert Cells. Choose Insert Sheet Rows to add entire rows. This does the same thing as right-clicking, just through the menu instead.

The menu method takes more clicks, so most people stick with right-clicking. But if you are using Excel on a touchscreen or prefer not to right-click, the menu is there.

Deleting rows you no longer need

If you add too many rows or want to remove rows with data you no longer need, the process is the same as inserting but in reverse. Click the row number to select it, right-click, and choose Delete. The rows below move up to fill the space.

Be careful: deleting a row removes all the data in it. Excel does not ask you to confirm unless you have set up a specific protection on the sheet. If you delete something by accident, press Ctrl+Z when ready to undo.

To delete multiple rows at once, select them the same way you would to insert — click the first row number, hold Shift, and click the last one. Then right-click and choose Delete.

What happens to formulas when you insert rows

If your spreadsheet has formulas that reference cells in other rows, inserting a new row can change those references. For example, if a formula in row 10 says =SUM(A1:A9) and you insert a new row at row 5, the formula automatically updates to =SUM(A1:A10) to include the new row in the sum.

This is usually what you want — Excel is smart enough to adjust formulas so they still work correctly. However, if you have a formula that intentionally references a specific row, inserting above it will change what that formula calculates. Check your formulas after inserting rows if your results look different than expected.

Deleting rows works the same way: formulas adjust automatically to account for the missing rows. Again, this is usually correct, but it is worth double-checking if your spreadsheet does calculations.

Inserting rows in the middle of your data

You can insert rows anywhere in your spreadsheet, not just at the bottom. Click the row number where you want the new row to appear, right-click, and select Insert. Everything below that row shifts down, and a blank row takes its place.

This is useful when you realize you forgot to enter data for a specific date or person in the middle of your list. Instead of retyping everything, insert a row at that spot and fill it in. All your other data stays in the same relative order.

If you insert a row in the middle of data that has formulas, those formulas update automatically. A sum that was adding rows 1 through 10 will now add rows 1 through 11 if you insert a new row in the middle.

Frequently Asked Questions

Can I undo inserting rows if I change my mind?

Yes. Press Ctrl+Z when ready after inserting rows, and Excel removes them and restores your spreadsheet to how it was before. You can undo multiple times if you need to go back several steps. If you have already saved the file, you cannot undo past the last save.

What is the maximum number of rows I can add to a spreadsheet?

Excel spreadsheets can hold over one million rows — specifically, 1,048,576 rows. Most people will never come close to this limit. If your spreadsheet is getting very large and slow, the issue is usually too many columns with data or too many formulas, not the number of rows.

Do I have to insert rows one at a time?

No. Select as many rows as you need by clicking the first row number, holding Shift, and clicking the last row number. Then right-click and insert. If you need 10 new rows, select 10 rows and insert once — Excel adds all 10 at the same time.

What happens to my data if I insert a row in the middle of it?

All data below the inserted row moves down one row. Data above the inserted row stays in place. If you have formulas that reference cells, they update automatically to account for the new row. Your data stays intact — nothing is deleted unless you specifically delete it.

Can I insert rows on a shared or protected spreadsheet?

It depends on the protection settings. If the spreadsheet is protected and the person who protected it did not allow inserting rows, you will see an error message when you try. Ask the person who set up the protection to either unprotect it or give you permission to insert rows.