How to Insert a Row in Excel Between Existing Data

How-to basics · Updated November 18, 2026

To insert a row between existing data in Excel, select the row heading immediately below where you want the blank row, right-click it, and choose Insert. Excel adds a blank worksheet row above your selection and shifts existing rows down. Before you start, save your workbook if the change could affect important data, and check whether your records are in a regular range or an Excel table.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows.
  • A clear idea of where the new row belongs. Excel inserts above the selected row, so identify the row that should move down.
  • Permission to edit the worksheet. A protected sheet or a read-only workbook may prevent you from inserting rows.

You do not need a formula or add-in for a basic row insertion. If the data is stored in an Excel table, use the table-specific option described below to add a record without unnecessarily inserting a worksheet-wide row.

Step-by-Step

  1. Find the position for the new row. Look at the row numbers along the left edge of the worksheet. If your list has headers in row 1 and you want a blank row between records in rows 7 and 8, you need to insert above row 8. You can click a cell in the record that should move down to confirm its row number.
  2. Check whether the list is a regular range or a table. Click a cell in the data. If Excel displays a Table Design tab on the ribbon, the data is an Excel table. A table has its own row-insertion behavior; use step 6 for a new record inside it. If the tab does not appear, continue with the regular worksheet-row method.
  3. Select the row heading below the intended gap. Click the numbered row heading at the far left, not just a cell in the row. For example, to create a gap between rows 7 and 8, click the heading for row 8. The entire row should become selected. Selecting the row heading makes clear that you intend to insert a complete worksheet row.
  4. Insert the row from the context menu. Right-click the selected row heading and choose Insert. Excel places a blank row above the selected row. Existing content in that row and every row below it moves down by one. The row numbers update automatically, and the newly inserted row is ready for data.
  5. Use the ribbon if you prefer menus. Select the row heading where the new row should go, then choose Home > Insert > Insert Sheet Rows. This does the same thing as the row-heading context menu. Make sure you choose Insert Sheet Rows rather than Insert Cells if you mean to add an entire worksheet row.
  6. Use the keyboard shortcut if useful. Select the row heading below the desired gap, then press Ctrl+Shift+= on Windows. On many keyboards this is described as Ctrl+Shift+plus; the plus sign may require the Shift key. If you select only a cell instead of the row heading, Excel may open an Insert dialog. Choose Entire row there, then select OK. On Mac, Control+Shift+= is the usual equivalent; if it does not work with your keyboard layout, use Home > Insert or the row-heading context menu. Excel for the web can also offer insertion from the row-heading context menu, though keyboard behavior can vary by browser.
  7. For a table, add a table row above the chosen record. Click a cell in the table row that should move down, right-click within that table row, and choose Insert > Table Rows Above if that option appears. This adds a row to the table rather than inserting a worksheet row across every column. If you are adding a record at the bottom, you can also click the last table cell and press Tab to create a new table row. Check the table boundaries afterward to make sure the new row is included.
  8. Enter the new information and review the result. Type or paste the values into the blank row. Check that each value is under the correct column heading, and review formulas, formatting, filters, and totals. If the new row should match neighboring rows, copy only the needed formatting or formulas rather than overwriting values you want to keep.
  9. Confirm that the surrounding data stayed intact. Compare the rows immediately above and below the insertion point with the original records. For a regular worksheet row, remember that cells in other columns on that same sheet also moved down, even if those columns were outside your visible list. If that movement is not what you wanted, use Undo immediately and choose a table row or cell-level insertion instead.

The main rule is simple: Excel inserts a worksheet row above the selected row. Selecting row 8 therefore creates a blank row 8, while the old row 8 becomes row 9. This is why selecting the row below the position you have in mind is usually the clearest approach.

Common Mistakes

  • Selecting the row above the intended gap. If you select row 7, Excel inserts above row 7, not between rows 7 and 8. The new row will be in the wrong place. If that happens, undo and select row 8 instead.
  • Clicking a cell when you mean to insert a full row. Inserting cells can shift only part of a worksheet and may leave columns misaligned. Select the numbered row heading or explicitly choose Entire row in the Insert dialog when a whole worksheet row is required.
  • Assuming a worksheet row affects only the visible list. A worksheet row spans every column, including columns outside the formatted data, and shifts their contents down too. If a separate dataset sits beside your list, a full-row insertion can change its position as well.
  • Adding a worksheet row when the data is a table. This may move unrelated worksheet content and is often broader than needed. Insert a table row above the record instead when you are adding an item within a table.
  • Pasting a complete row over existing records. Pasting copied data into a row is not the same as inserting space first. If you paste without inserting, you can replace values that were already there. Insert the row, then paste into the blank space.
  • Forgetting formulas, filters, or totals. Excel often adjusts nearby formulas when rows are inserted, but do not assume every reference, external link, or manually maintained total is correct. Check the affected calculations and whether the table or filter includes the new record.

Tips

  • Insert several rows at once. Select the same number of row headings as the number of blank rows you need, starting at the row that should move down. For example, selecting headings 8, 9, and 10 and choosing Insert adds three blank rows above the original row 8. This is faster and helps keep the additions together.
  • Use the Name Box to navigate to a distant row. The Name Box is to the left of the formula bar. Enter a cell reference such as A250 and press Enter to jump to that row, then click its row heading to select the full row. This is useful on long sheets where scrolling precisely is awkward.
  • Keep a backup for high-impact edits. Save the workbook before changing a complex report, or use Save As to make a working copy. This is especially sensible when the sheet contains linked data, structured references, or multiple lists side by side.
  • Use Undo for an immediate correction. If you inserted in the wrong place, press Ctrl+Z on Windows or Command+Z on Mac before making other changes. Undo is most reliable immediately after the insertion; later actions can make it harder to return to the exact prior state.
  • Let a table handle new records. Tables typically extend their formatting and calculated-column formulas when a row is added within the table. After insertion, inspect the first and last columns and confirm the new record is inside the table, especially if you rely on filters or a Total Row.
  • Consider a blank row’s effect on sorting. If you plan to sort a list, keep the records together and avoid leaving a blank worksheet row in the middle. A blank line can cause Excel to identify only part of a contiguous data region when you sort or select it. Add the row, fill it, and then sort the complete dataset.

Troubleshooting

Insert is unavailable or Excel will not add a row: Check whether the worksheet is protected by opening Review > Unprotect Sheet. You may need the password set by the workbook owner. If the file is read-only or opened in Protected View, enable editing only if you trust the file and have permission to change it. Shared-workbook permissions or organizational controls can also limit editing.

The row appeared in the wrong place: Press Ctrl+Z on Windows or Command+Z on Mac, then select the row heading immediately below the desired position and insert again. If you have already made other changes, inspect the sheet before undoing several actions so you do not remove work you want to keep.

Only some cells moved, or columns no longer line up: You probably inserted cells rather than a complete row. Undo the change if possible, select the row number on the left, and use Insert Sheet Rows. If you intentionally need to shift only part of the data, use the Insert dialog carefully and choose the appropriate shift direction instead of assuming a full row is needed.

Other data moved unexpectedly: A worksheet row affects the entire sheet width. Undo if the change should not affect neighboring lists. For a table, add a table row above the target record. For a regular range where only selected columns should shift, use Insert Cells and choose a shift direction, but first check that this will not break the alignment of the surrounding records.

The new table row is not included in a filter or total: Confirm that the row is inside the table boundary. Click in the table and look for the table outline, then use the table-specific Insert > Table Rows Above option from the target record. If the row was added outside the table, undo and insert it within the table, or resize the table using Table Design > Resize Table and select the correct range.

Formatting or formulas do not match nearby rows: Check whether the inserted row is part of a table and whether the neighboring cells contain consistent formatting or calculated-column formulas. Copy the appropriate formatting or formula into the new row, then verify that references point to the intended records. Avoid copying an entire neighboring row if it would duplicate values or overwrite labels.

Frequently Asked Questions

How do I insert a row between two rows in Excel?
Select the heading of the lower row, right-click it, and choose Insert. Excel adds a blank row above that row, which places it between the two existing rows.

Can I insert more than one row at a time?
Yes. Select as many row headings as the number of blank rows you need, beginning at the position where the new rows should appear. Choose Insert once; Excel inserts the same number of rows above the selected rows.

Will inserting a row change my formulas?
Excel commonly adjusts references in formulas when rows are inserted, but results depend on how the formulas and references are set up. Check nearby calculations, totals, external links, and any formulas that refer to a fixed range after inserting.

What is the difference between inserting a worksheet row and a table row?
A worksheet row spans all columns and moves cells below it down across the sheet. A table row adds a record within the table, which is usually the better choice for adding data to a structured list without shifting unrelated worksheet content.

Can I insert a row in Excel for the web or on Mac?
Yes. In Excel for the web, select the row heading and use its context menu to insert above, or use the available Insert command on the ribbon. On Mac, use the row-heading context menu or Home > Insert; keyboard shortcuts can differ by keyboard layout.

Why did Excel insert a blank row above my data instead of below it?
Excel inserts above the selected row heading. To place a blank row between two records, select the heading of the record that should move down. Selecting the row above the gap places the blank row before that row instead.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.