The quickest way to add a row

Right-click on the row number where you want the new row to appear, then click Insert. Excel adds a blank row above the one you clicked, and shifts everything below it down. If you want to add multiple rows at once, click and drag across several row numbers first, then right-click and insert — Excel will add as many rows as you selected.

You can also use the menu: click the row number to select it, then go to the Home tab at the top, find the Insert button in the toolbar, and click the small arrow next to it. Choose Insert Sheet Rows. This does the same thing as right-clicking.

The new row always goes above the row you selected. If you want to add a row at the very bottom of your data, click the row number just below where your data ends, then insert.

Key Takeaways

  • Right-click any row number and select Insert to add a blank row above it, pushing existing data down.
  • Select multiple row numbers at once by clicking and dragging, then insert to add that many rows in one step.
  • The new row appears above the row you selected, so pick your target carefully or you will need to move data afterward.
  • You can undo a row insertion by pressing Ctrl+Z (or Cmd+Z on Mac) if you added it by mistake.

Adding rows in the middle of existing data

When you insert a row in the middle of a spreadsheet, Excel moves everything below it down one row. Formulas that reference cells in those rows update automatically — if a formula pointed to row 5 and you insert a row at row 3, that formula now points to row 6. This usually works the way you want, but check any calculations that span a range to make sure they still include what you intended.

If you have data in columns to the right that you do not want to move, inserting a row will move that too. Excel does not let you insert a row in only part of the spreadsheet. If you need to add data without shifting columns, use a blank column instead, or copy your data to a new location where you have room.

Adding rows at the end of your data

You do not have to insert a row at the end — you can just click the first empty cell below your data and start typing. Excel treats any filled cell as part of your data range, so if you want to keep your spreadsheet organized, it is cleaner to click the row number just below your last row of data and insert a row there first.

If you are working with a table (data formatted with the Format as Table option), Excel adds a new row automatically when you click the first empty cell below the table and start typing. You do not need to insert manually.

Inserting rows without losing formatting

When you insert a row, it starts blank — no colors, borders, or number formats from the rows around it. If you want the new row to match the formatting of nearby rows, select a row that has the formatting you want, copy it, then right-click where you want to insert and choose Insert Copied Cells. This adds a row with the same colors and borders as the row you copied.

Alternatively, after you insert a blank row, select it and use the Format Painter tool. Click the row with the formatting you want to copy, then click the Format Painter button (it looks like a paintbrush in the Home tab), and click the new row. This copies only the formatting, not the data.

Deleting rows you no longer need

To remove a row, right-click its row number and click Delete. Everything below it shifts up. If you delete by mistake, press Ctrl+Z (or Cmd+Z on Mac) to undo when ready.

If you want to keep the row but clear its contents, right-click and choose Clear Contents instead of Delete. This removes the data but leaves the row in place, which is useful if you have formulas or formatting you want to preserve.

Working with large spreadsheets

In a spreadsheet with thousands of rows, inserting rows one at a time can be slow. If you need to add many rows, select all of them at once before inserting. Click the first row number you want, hold Shift, and click the last row number — Excel highlights all rows in between. Then right-click and insert. This adds all the rows in a single operation, which is faster than inserting them one by one.

If your spreadsheet has formulas that reference specific row numbers (like =SUM(A1:A100)), inserting rows in the middle will change those references. Check your formulas after inserting to make sure they still calculate what you intended. Using named ranges instead of row numbers can prevent this problem in future spreadsheets.

Frequently Asked Questions

Can I insert a row in the middle without moving the rows below it?

No. Inserting a row always shifts everything below it down. If you need to add data without moving existing rows, insert the data in a blank column to the right instead, or add it below your current data and rearrange later.

What happens to formulas when I insert a row?

Formulas update automatically. If a formula pointed to row 5 and you insert a row at row 3, the formula now points to row 6. Check formulas that use ranges (like =SUM(A1:A10)) to make sure they still include the cells you want.

How do I add a row at the very top of my spreadsheet?

Click row number 1, then right-click and select Insert. The new row becomes row 1, and everything else shifts down. This is useful if you want to add a title or header row above existing data.

Can I insert a row without using the right-click menu?

Yes. Select the row by clicking its number, then go to the Home tab and click the Insert button (or the arrow next to it) and choose Insert Sheet Rows. You can also use the keyboard shortcut by selecting the row and pressing Ctrl+Plus (on Windows) or Cmd+Plus (on Mac).

What is the difference between Insert and Insert Copied Cells?

Insert adds a blank row. Insert Copied Cells adds a row and fills it with a copy of whatever you copied beforehand — useful for adding a row with the same formatting as an existing row without having to format it manually.