The fastest way to add rows in Excel

To add a single row in Excel, right-click on the row number where you want the new row to appear, then select Insert from the menu. Excel will insert a blank row above the row you clicked on. If you want the new row below instead, right-click on the row number directly below where you want it, then insert.

You can also select a row by clicking its number on the left side of the spreadsheet, then go to the Home tab at the top, click the dropdown arrow next to Insert, and choose Insert Sheet Rows. Both methods do the same thing — the right-click approach is usually faster if you only need one or two rows.

If you need to add multiple rows at once, select as many row numbers as you want to insert. Click the first row number, hold Shift, and click the last row number. Then right-click and select Insert. Excel will add that many blank rows above your selection.

Key Takeaways

  • Right-click a row number and select Insert to add a blank row above it in one step.
  • To insert multiple rows at once, select several row numbers by holding Shift, then right-click and insert.
  • The Home tab also has an Insert dropdown if you prefer using the ribbon instead of right-clicking.
  • Inserting a row shifts everything below it down — your existing data stays intact and moves with the row it was in.

Inserting rows at the end of your data

If you want to add rows at the bottom of your spreadsheet, you do not need to insert them — you can simply click on an empty row and start typing. Excel will treat it as part of your data automatically. This is the simplest approach when you are adding new information after your existing entries.

However, if you want to add rows in the middle of your data and keep everything organized, inserting is the right choice. When you insert a row, Excel moves all the data below it down one row, so your formulas and references stay connected to the correct cells.

What happens to formulas when you insert a row

When you insert a row, any formulas in the rows below automatically adjust to reference the new row numbers. For example, if you have a SUM formula that adds cells A1 through A10, and you insert a row at position 5, the formula updates to A1 through A11 — it includes the new row without you having to change anything.

This automatic adjustment is one of the main reasons to use Insert instead of just adding data at the bottom. Your calculations stay accurate even as you reorganize your spreadsheet. If you delete a row, the same thing happens in reverse — formulas shrink to exclude the deleted row.

Inserting rows using the keyboard

If you prefer keyboard shortcuts, select the row or rows where you want to insert new ones, then press Ctrl + Plus (on Windows) or Cmd + Plus (on Mac). A dialog box will appear asking whether you want to insert entire rows or shift cells. Choose Entire row and click OK.

This shortcut works the same way as right-clicking — it inserts rows above your selection. If you use this method often, the keyboard shortcut can be faster than moving your hand to the mouse.

Undoing an inserted row

If you insert a row by mistake, press Ctrl + Z (Windows) or Cmd + Z (Mac) to undo. This works immediately after you insert. Excel will remove the row and move your data back to where it was.

You can undo multiple steps in a row by pressing the shortcut several times. If you have already saved your file, undo will not work — you will need to delete the row manually instead. This is why it is a good idea to undo right away if you make a mistake.

Deleting rows you no longer need

To remove a row, right-click its row number and select Delete. Excel will remove the row and shift everything below it up. To delete multiple rows, select them the same way you would select them for inserting — click the first row number, hold Shift, click the last one, then right-click and delete.

Deleting is permanent once you save, so double-check that you are removing the right rows. If you delete by mistake, use Ctrl + Z to undo before you save the file.

Frequently Asked Questions

Can I insert a row between two rows without losing data?

Yes. When you insert a row, Excel moves all the data below it down one row. Nothing is deleted — it all shifts down. Your data stays intact and moves with the row it was in.

What is the difference between inserting and just typing in an empty row?

Inserting is useful when you need to add a row in the middle of your data and keep everything organized. Typing in an empty row at the bottom is simpler if you are just adding new information after your existing entries. Inserting also updates any formulas automatically, while adding at the bottom requires you to adjust formulas yourself if they reference the rows you are adding to.

Does inserting a row affect my charts or pivot tables?

Charts and pivot tables that reference your data will usually update automatically when you insert a row, as long as they are set to include the entire data range. If you built a chart from specific cells, inserting a row outside that range will not affect it. Check your chart settings if you are unsure.

Can I insert a row in the middle of a frozen pane?

Yes, you can insert rows anywhere in your spreadsheet, including in frozen panes. The insertion works the same way — right-click the row number and select Insert. Your frozen panes stay in place.