The fastest way to add a row is right-click and insert
Right-click on the row number where you want the new row to appear, then click Insert. Excel shifts everything below down by one row and leaves the new row empty. If you right-click on row 5, the new row becomes row 5, and what was row 5 moves to row 6.
This works the same way whether you have 10 rows or 10,000. The row you right-click on is where the insertion happens — not below it. If you want to add a row at the very bottom of your data, click on the row number just below your last row of information.
You can also select multiple row numbers at once by holding Shift and clicking, then right-click and insert. If you select rows 5 through 7 and insert, Excel adds three new blank rows starting at row 5.
Key Takeaways
- Right-click the row number where you want the new row, then click Insert — the new row appears at that position and everything below shifts down.
- You can insert multiple rows at once by selecting several row numbers with Shift+click, then right-clicking and choosing Insert.
- The Home tab in the ribbon also has an Insert option if you prefer not to use the right-click menu.
- Inserting a row is different from adding data to an empty row — inserting moves your existing data down, while adding to an empty row leaves everything else in place.
Using the Home tab menu instead of right-click
If you prefer the ribbon menu, click the row number to select it, then go to the Home tab. In the Cells group on the left side, click the dropdown arrow next to Insert, then choose Insert Sheet Rows. This does exactly what right-click does, just through the menu instead.
The Home tab method is useful if your right-click menu is customized or if you are working on a touchscreen where right-clicking is awkward. The result is identical either way — a new blank row at the position you selected, with everything below it pushed down one row.
Adding data to an empty row versus inserting a new row
These are two different things. Adding data to an empty row means you click on a cell in a row that already exists but has no data in it, and you type something. Nothing moves. Inserting a row means you create a brand new row and shift all the rows below it down by one.
If you have data in rows 1 through 10 and you click on row 15 and start typing, you are adding data to an empty row. Rows 11 through 14 stay empty. If instead you right-click on row 11 and insert, you create a new blank row 11, and what was rows 11 through 10 become rows 12 through 11.
Most of the time, you want to insert a row when you are in the middle of a list and need to add something in order. You want to add data to an empty row when you are appending information to the end of your list.
What happens to formulas and formatting when you insert a row
When you insert a row, Excel copies the formatting from the row above it — colors, fonts, borders, and column widths all match. This keeps your spreadsheet looking consistent without extra work.
If the rows above or below your new row contain formulas, Excel usually adjusts them automatically. For example, if row 10 has a formula that adds up rows 1 through 9, and you insert a new row 5, that formula updates to add rows 1 through 10 (skipping the new empty row 5). This happens because Excel recognizes that you inserted a row in the middle of the range, not at the end.
However, if your formula refers to a specific row number — like =A5+B5 — and you insert a row above it, the formula moves down with the row it was in. The cell reference updates to match. This is usually what you want, but it is worth checking your formulas after inserting rows in the middle of calculations.
Inserting rows in the middle of a sorted or filtered list
If your spreadsheet is sorted by a column — like alphabetically by name or by date — inserting a row in the middle does not re-sort it. The new row stays exactly where you inserted it, even if it breaks the sort order. You will need to re-sort the data afterward if you want it in order again.
If you have filters applied (the dropdown arrows in the header row), inserting a row adds it to the hidden data as well. The new row appears in the position you selected, but if that position is currently hidden by a filter, you will not see it until you clear the filter or adjust it to show that row.
The safest approach is to turn off sorting and filters before inserting rows in the middle of a list, then turn them back on afterward. This prevents confusion about where the new row ended up and keeps your data organized the way you intended.
Undoing an insertion if you made a mistake
If you inserted a row by accident, press Ctrl+Z (or Cmd+Z on Mac) when ready. This undoes the insertion and brings back any data that was shifted down. You can undo multiple times if you need to reverse several actions.
The undo history in Excel goes back many steps, so even if you inserted a row several actions ago, you can usually undo it. Click the dropdown arrow next to the undo button in the top left to see your recent actions and jump back to before the insertion happened.
Frequently Asked Questions
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 appears at the top, and everything else shifts down. Your headers or first line of data moves to row 2.
What if I want to add multiple rows at different places, not all together?
Insert them one at a time, starting from the bottom and working up. If you insert at the top first, all your row numbers change, which makes it harder to find where you wanted to insert the next one. Working from bottom to top keeps the rows above your insertion point in the same place.
Does inserting a row change the file size?
Not noticeably. Excel files are designed to handle thousands of rows. Adding a few rows does not make a meaningful difference in file size. If you are working with a very large spreadsheet that is already slow, inserting rows will not speed it up or slow it down significantly.
Can I insert a row between two cells in the same row?
No. You insert entire rows, not individual cells. If you want to add a column between two columns, you right-click on a column letter instead of a row number. Rows always insert horizontally across the entire spreadsheet.