Right-click the row number where you want the new row to appear

To insert a new row in Excel, right-click on the row number on the left side of the spreadsheet — the gray column that shows 1, 2, 3, and so on. A menu will appear with several options. Click Insert (or Insert 1 if your version says that). Excel will create a blank row at that position and shift everything below it down by one row.

The new row takes on the same formatting as the row above it — fonts, colors, borders, and cell width all match. This keeps your spreadsheet looking consistent without extra work.

If you need to insert multiple rows at once, select several row numbers before right-clicking. For example, click row 5, then hold Shift and click row 8 to select rows 5 through 8. Right-click and choose Insert, and Excel will add three new blank rows in that space.

Key Takeaways

  • Right-click the row number where you want the new row, then click Insert from the menu that appears.
  • The new row inherits formatting from the row above it, so borders and colors stay consistent.
  • To insert multiple rows at once, select several row numbers by clicking the first, holding Shift, and clicking the last, then right-click and choose Insert.
  • You can also use the Home tab at the top, click the Insert dropdown arrow, and choose Insert Sheet Rows.
  • Inserting a row does not delete any data — it pushes existing rows down and creates space for new information.

Using the menu bar instead of right-clicking

If you prefer not to right-click, you can insert a row using the ribbon at the top of Excel. First, click on the row number where you want the new row to go. Then click the Home tab if it is not already selected. In the toolbar, find the button labeled Insert (it usually has a small dropdown arrow next to it). Click the arrow and select Insert Sheet Rows.

This method works the same way as right-clicking — it adds one blank row at the position you selected and shifts everything below it down. Some people find the menu bar easier to remember, especially if they use Excel regularly and want to avoid the mouse movement of right-clicking.

What happens to your data when you insert a row

When you insert a new row, Excel does not delete or overwrite anything. Instead, it moves all the data that was in that row and every row below it down by one position. If row 5 had customer names and row 6 had addresses, inserting a new row at position 5 will move the names to row 6 and the addresses to row 7, leaving row 5 blank for you to fill in.

Any formulas that reference rows below the insertion point automatically adjust. For example, if you had a formula in row 10 that added up values from rows 1 through 9, and you insert a new row at position 5, that formula will now add rows 1 through 10 instead. Excel handles this adjustment without you having to fix the formula manually.

Inserting a row at the end of your data

If you want to add a new row after your last row of data, you do not need to insert — you can straightforward click on the first empty row below your data and start typing. Excel will automatically format it to match the rows above.

However, if you want to insert a row in the middle of your data or at a specific position, use the right-click or menu method described above. Inserting is useful when you realize you forgot information that belongs between two existing rows, or when you need to add a new entry in a particular order.

Undoing an accidental insertion

If you insert a row by mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo the action. Excel will remove the row you just added and restore everything to its previous position. You can undo multiple times if you need to go back several steps.

If you have already saved the file after inserting the row, you cannot undo through the keyboard. In that case, you will need to manually delete the row by right-clicking its row number and choosing Delete, then move any data back to where it belongs.

Inserting rows in a filtered or sorted spreadsheet

If your spreadsheet is filtered (showing only certain rows based on criteria) or sorted (arranged in a specific order), inserting a new row can behave differently. The new row will appear at the position you selected, but it may not be visible if it does not match your current filter. If you insert a row while a filter is active, turn off the filter afterward to see where the new row ended up.

When working with sorted data, insert the row first, then sort again if you need to maintain a specific order. This prevents confusion about where the new row will appear in relation to your sorted columns.

Frequently Asked Questions

Can I insert a row between two rows that have formulas?

Yes. Excel automatically adjusts any formulas that reference the rows below the insertion point. If a formula was adding rows 5 through 10 and you insert a new row at position 6, the formula updates to include the new row 6 and shifts the old rows down.

What is the difference between inserting a row and adding data to an empty row?

Inserting a row creates space in a specific position and pushes everything below it down. Adding data to an empty row just fills in that empty space without moving anything. Use insert when you need a new row in a particular spot; use an empty row when you are adding to the end of your data.

Can I insert a row at the very top of my spreadsheet?

Yes. Click on row number 1, right-click, and choose Insert. A new row 1 will appear, and your current row 1 becomes row 2. This is useful if you want to add a title or header row above your existing data.

Does inserting a row change the file size?

Slightly, because you are adding a new row to the spreadsheet. However, the change is minimal — a single empty row takes very little space. Inserting rows does not significantly affect how fast the file opens or how much storage it uses.

What if I insert a row by mistake in a shared spreadsheet?

Undo when ready with Ctrl+Z if you catch it right away. If others are editing the same file, let them know so they can refresh their view. In shared spreadsheets, changes sync across all users, so an accidental insertion affects everyone viewing the file.