How to Insert a Row in Excel After Any Specific Row

To insert a blank row after a specific row in Excel, select the row number directly below it, then choose Home > Insert > Insert Sheet Rows. Excel adds a new row above your selection, so selecting row 6 inserts a blank row after row 5. Save the workbook first if the data is important, especially before making several structural changes.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same basic method works in Excel for Mac and Excel for the web, although some menu labels or shortcuts may differ slightly.
The number of the row that should come before the new blank row. For example, if you want the new row after row 12, you will select row 13.
Edit access to the worksheet. A protected sheet or a read-only workbook may prevent row insertion.

Step-by-Step

Identify the row where the new row should go. Look at the row numbers along the left edge of the worksheet. If you want a blank row between rows 5 and 6, the new row belongs after row 5 and before the current row 6. Excel inserts rows above a selected row, which is the key detail to remember. You do not select the row that should remain above the new row; you select the row that should move down.
Select the row immediately below the desired position. For a row after row 5, click the number 6 in the row header at the far left. The entire row should become highlighted. If the row number is difficult to see because the sheet is zoomed in or scrolled, use the vertical scroll bar to locate it. You can also click a cell in row 6 and use the Home ribbon command, but selecting the row header makes it clear that Excel should insert a whole worksheet row.
Insert the row from the ribbon. With the row selected, go to Home > Insert > Insert Sheet Rows. In some Excel window sizes, the Insert button appears as a small icon in the Cells group; open its menu and choose Insert Sheet Rows. Excel creates a blank row above the selected row. The former row 6 and all rows beneath it shift down by one, while row 5 stays in place.
Use the right-click menu if you prefer. Instead of the ribbon, right-click the selected row number and choose Insert. This also inserts a full worksheet row above the selected one. If you right-click inside a cell rather than on the row number, Excel may show a different menu or open an Insert dialog. In that case, choose the option for an entire row, or cancel and right-click the row header to avoid inserting only some cells.
Use a keyboard shortcut when the whole row is selected. In Excel for Windows, select the row header and press Ctrl+Shift++ (hold Ctrl and Shift, then press the plus key; on many keyboards this is Shift with the equals key). If Excel opens an Insert dialog, choose Entire row and confirm. In Excel for Mac, the corresponding shortcut is generally Control+Shift+=, though keyboard layouts can affect the key combination. If it does not work, use the ribbon or right-click menu instead. Excel for the web may handle shortcuts differently depending on the browser, so the ribbon command is the dependable option there.
Enter information in the new row. Click a cell in the new blank row and type the required values. If the worksheet has headings in row 1, keep the new record below the headings rather than inserting above them unless you intend to move the header. For a list with columns such as Date, Item, and Amount, enter each part of the new record in the matching column so later sorting and filtering continue to work.
Check the surrounding data and formulas. Confirm that the new row is in the intended position and that the rows below it shifted down. Excel usually adjusts references in formulas when a row is inserted, but review totals, charts, named ranges, and dependent worksheets if they are important. If the new row should copy the formatting of nearby records, use the Insert Options icon that may appear beside the inserted row, or copy formatting from an adjacent row after inserting.

Example: Suppose a worksheet has a heading in row 1 and records in rows 2 through 20. To add a record after the entry in row 8, click the row number 9, then choose Home > Insert > Insert Sheet Rows. The existing row 9 becomes row 10, and the new blank row is now row 9. This method works even if the worksheet contains values in many columns; selecting the row header inserts across the full sheet rather than shifting only one column.

Common Mistakes

Selecting the row above the intended position. Excel inserts above the selected row. Selecting row 5 inserts before row 5, not after it. For a new row after row 5, select row 6.
Selecting a cell and inserting only cells. If you select one cell and use an insert command, Excel may ask whether to shift cells down or right. That can misalign data across columns. Select the row number for a full worksheet row, or explicitly choose Entire row in the dialog.
Inserting a row into a formatted Excel table as if it were an ordinary range. A table has its own row structure and may expand or apply table formatting automatically. Use the table-specific command described in the Tips section when you need a new record inside a table.
Forgetting that row numbers change below the insertion. After adding a row, a row that used to be row 10 becomes row 11. If you are following instructions that refer to fixed row numbers, verify the position again before repeating the operation.
Inserting above the column headings by accident. If the header row is selected, a new row appears above it and may disrupt filters or table labels. For a record below the headings, select the first data row or the row directly below the intended record.

Tips

Add several blank rows at once. Select the same number of row headers as the number of rows you want to add, starting at the row immediately below the desired location. For example, to add three rows after row 5, select row headers 6, 7, and 8, then use Insert Sheet Rows. Excel inserts three rows above the selected block. Check the highlight before inserting so you do not choose one extra or one too few.
Insert inside an Excel table. Click a cell in the table row that should move down, right-click, and choose Insert > Table Rows Above. To add a row after a particular table record, select the table row immediately below that record. Another option is to click the last cell in the table’s final row and press Tab; Excel creates a new table row at the bottom. The Tab method adds to the end, not to an arbitrary position in the middle.
Preserve the visual style. Excel may copy formatting from a nearby row, and an Insert Options button can appear after insertion. Use it to select an available formatting choice, such as matching the formatting above or below. If the new row looks different, copy formatting from a neighboring row with Format Painter or use the table’s built-in banded-row style.
Use Undo immediately if the placement is wrong. Press Ctrl+Z on Windows or Command+Z on Mac to undo an unintended insertion, then select the correct row and try again. Once you have made many more edits, undoing may also reverse those later changes, so check the placement promptly.
Make a backup before large edits. Inserting one row is usually straightforward, but changing a workbook with linked formulas, reports, or macros can affect other parts of the file. Save a copy before inserting many rows or editing a shared, business-critical workbook.

Troubleshooting

The Insert option is unavailable or greyed out. The worksheet may be protected, the workbook may be open as read-only, or your account may not have permission to edit it. Check the Review tab for an Unprotect Sheet command; if the sheet requires a password, ask the workbook owner rather than trying to bypass protection. If the file is read-only, save an editable copy or request edit access.

Excel inserted cells instead of a whole row. Undo the change before continuing. Click the row number at the left so the full row is highlighted, then choose Home > Insert > Insert Sheet Rows. If you used the cell-level Insert command and received a dialog, choose Entire row. Avoid choosing Shift cells down when your data spans multiple columns, because values in neighboring columns may no longer line up.

The row appeared in the wrong place. Remember that insertion happens above the selected row. If you wanted a row after row 12 but selected row 12, Excel inserted before the original row 12. Undo, select the row directly below the target, and insert again. If you have already made other changes, carefully inspect the sheet before using Undo so you do not remove work you want to keep.

The command behaves differently in a table. If the data is formatted as an Excel table, a standard sheet-row insertion can affect the worksheet outside the table as well. For an in-table row, select the table row that should move down and use the table context menu’s Insert > Table Rows Above command. If you cannot see that option, make sure the active cell is inside the table, not beside it.

The new row does not match nearby formatting or formulas. Excel may not copy every custom format or formula in the way you expect, especially in a range that is not an Excel table. Copy the relevant cells from an adjacent row and use Paste Special for formats or formulas as needed, checking that relative references are appropriate. In a table, confirm that calculated-column formulas and table formatting are enabled and consistent.

Excel reports that it cannot insert a row. A worksheet has a maximum of 1,048,576 rows. Insertion can also be blocked when cells at the bottom of the sheet contain formatting or other content that Excel would need to move beyond the limit. Use Ctrl+End on Windows to inspect the last used cell, remove genuinely unnecessary content below your data, save the workbook, and try again. Be cautious: clearing content is different from deleting rows, and you should not remove data you still need.

Frequently Asked Questions

How do I insert a row after row 10?
Click the row number 11, then choose Home > Insert > Insert Sheet Rows. Excel inserts the blank row above the selected row 11, which places it after row 10.

Can I insert more than one row at a time?
Yes. Select as many row headers as the number of blank rows you need, beginning with the row directly below the target location. Use Insert Sheet Rows once, and Excel inserts the same number of rows above the selected block.

Will inserting a row change my formulas?
Excel generally updates worksheet references to account for an inserted row, but results depend on how formulas, named ranges, charts, and external links are set up. Check important totals and reports after the change, particularly when formulas refer to fixed ranges or other worksheets.

Can I add a row in the middle of a filtered list?
Yes, but first make sure you understand which worksheet row is selected. Filters can hide records, so visible records may not be next to each other by row number. For an Excel table, use Insert > Table Rows Above on the table row that should move down. For a regular range, select the actual row number where the blank row should be inserted.

Does this work in Excel for Mac and Excel for the web?
Yes. Select the row header below the insertion point and use the Insert command on the Home ribbon, or right-click the row header. Keyboard shortcuts can differ by operating system, keyboard layout, and browser, so the ribbon method is the most consistent option across versions.

How do I insert a row at the bottom of an Excel table?
Click the final cell in the table’s last row and press Tab to create a new table row. You can also type into the first row immediately below the table, which may cause the table to expand if Excel recognizes the adjacent entry as part of the table.

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.