Insert Row Below in Excel: Steps, Shortcuts, and Fixes

To insert a row below a particular row in Excel for Microsoft 365 on Windows, select the row header directly beneath where the new row should go, then choose Home > Insert > Insert Sheet Rows. Excel inserts a blank row above the selected row, which places it below the row you chose as your reference. You can also right-click that row header and choose Insert.

How Excel places an inserted row

Excel inserts worksheet rows above the row or rows you select; it does not offer a separate command that inserts a worksheet row below the selection. That distinction explains why selecting the row you want to follow can feel backward at first. For example, to add a row between rows 8 and 9, select row 9 and insert a sheet row. The existing row 9 moves down, and the new blank row takes its place.

Row headers are the numbered boxes along the left edge of the worksheet. Clicking a number selects the entire row, which tells Excel to insert a full worksheet row rather than shift only a few cells. If you need to add several consecutive rows, select the same number of row headers first. For instance, select rows 9 through 11 to insert three rows above the original row 9.

For a quick mouse-based method:

Find the row that should appear immediately below the new space.
Right-click its row number at the left of the worksheet.
Choose Insert from the menu.
Check that the new blank row is in the intended position before entering data.

The ribbon route is useful when the row headers are difficult to right-click or when you want to see the command explicitly: select the destination row header, then use Home > Insert > Insert Sheet Rows. The Insert button also has options for inserting cells and columns, so choose Insert Sheet Rows when you mean a complete worksheet row.

Keyboard shortcuts on Windows

A keyboard method can be faster when you are adding rows repeatedly. Select the row directly below the desired insertion point, then press Ctrl+Shift+=. On many keyboards, the plus sign shares the equals key, so this is commonly described as Ctrl+Shift+Plus. Excel opens the Insert dialog if the selection does not make the intended insertion type clear; choose Entire row if prompted, then confirm.

You can select a whole row from the keyboard by placing the active cell anywhere in it and pressing Shift+Space. Then use the insert shortcut. To add multiple rows, select multiple complete rows first—for example, use the row headers or extend a row selection—then insert. The number of selected rows determines how many rows Excel adds.

Keyboard layouts and Excel settings can affect which key combination feels reliable. If the shortcut does not work, use the ribbon or row-header menu rather than repeatedly pressing keys and risking an unintended edit. On Excel for Mac, use the Insert command from the menu or ribbon if the Windows shortcut does not match your keyboard; shortcuts can differ by keyboard layout and version. Excel for the web also has a different browser and operating-system shortcut environment, so the row-header context menu is a dependable alternative there.

Inserting a row in an Excel table

An Excel table is a formatted, structured data range with filter buttons and table-specific behavior. It is not quite the same thing as an ordinary worksheet range. If the data is a table, right-click a cell in the table row that should move down and choose Insert > Table Rows Above. That adds a table row above the selected table row, which is the way to put one below the preceding table row.

For example, if a table has records for January, February, and April and you need to add March between February and April, use the table row for April as the insertion point. Inserting a table row above April keeps the new record within the table, so table formatting, filter coverage, and calculated-column behavior can extend as appropriate. A blank worksheet row inserted outside the table may not become part of the table, even if it appears visually adjacent.

At the end of a table, another option is to click the last cell in its final row and press Tab. Excel creates a new table row when you tab out of that last cell. This is convenient for appending records, but it does not insert a row in the middle. To insert in the middle, use the table-row command. If the right-click menu shows worksheet options rather than Table Rows Above, confirm that the selected cell is actually inside the table.

Choose between a whole row and shifted cells

Use Insert Sheet Rows when the new information belongs across the full worksheet and existing records below it should move down together. Inserting only cells is different: Excel shifts a selected group of cells down or to the right, leaving other cells in the same worksheet rows untouched. That can be useful for a small layout adjustment, but it can misalign records if the sheet is organized as a table with related values spread across columns.

Before inserting, consider how the surrounding data is organized:

One record per worksheet row: insert a full sheet row or a table row so fields such as name, date, and amount stay together.
A small block inside a larger layout: use Insert Cells only if shifting those cells will not break relationships with neighboring content.
A formatted Excel table: insert a table row to keep the new record within the table structure.
A totals or notes area beneath data: check whether the area is part of the table or a separate worksheet section before inserting.

A common misconception is that a row inserted below a selection should be placed after the selected row. Excel’s standard insert behavior is above the selection. Thinking in terms of the row that must move down makes the correct choice clear: select that row, not the row that should stay above the new one.

Formatting and formulas after insertion

Excel generally carries formatting into an inserted row from nearby rows, but the exact appearance can depend on the surrounding cells and how the row was inserted. If the new row has unexpected borders, fills, number formats, or shading, use the Insert Options button that may appear beside the inserted cells to choose a formatting option. You can also copy a nearby row’s formatting with Format Painter or adjust the relevant cells with the Home tab controls.

In a table, the table style normally supplies alternating banded rows and other table formatting. If a new row appears plain or differently styled, verify that it was inserted inside the table rather than beside it. Table formulas in calculated columns may fill into an added table row automatically, but check the result, especially if the column contains manually edited formulas or exceptions.

Worksheet formulas that refer to cells around an inserted row often adjust their references as Excel updates the sheet. However, do not assume every workbook calculation or external link will behave exactly as intended. Named ranges, formulas that use fixed text-based addresses, charts, queries, and references in other workbooks can have their own behavior. After inserting a row in a model or shared report, inspect key totals and any dependent outputs rather than relying only on how the cells look.

Common problems and how to fix them

If Insert is unavailable or Excel refuses to add a row, check whether the worksheet is protected. A protected sheet can restrict structural changes; the owner may need to unprotect it or allow row insertion. If the workbook is shared or controlled by organizational permissions, you may also need the appropriate access before making structural edits.

Another frequent issue is selecting cells rather than the row header. If you choose Insert while only a cell is selected, Excel may ask whether to shift cells down or insert an entire row. Choose Entire row when the goal is a worksheet-wide row. If you accidentally shift only part of the data, undo immediately with Ctrl+Z on Windows and inspect the surrounding records.

Large merged-cell areas can complicate row insertion because merges may span different parts of the intended insertion area. If Excel reports that it cannot complete the operation, review merged cells near the insertion point and consider unmerging or restructuring them before trying again. Hidden rows can also make the result appear to be in the wrong place. Unhide or inspect neighboring rows if the visible numbering seems to skip.

When a filter is active, inserting a row into a filtered list can be confusing because some records are hidden. Clear or review the filter if you need to understand the full order of the data. In a table, use the table-specific insertion command, then check that the new record is included in the table and that its values are not hidden by the current filter.

Undo, review, and safer alternatives

If you have just inserted the wrong row, press Ctrl+Z on Windows or use the Undo button on the Quick Access Toolbar. Undo is most useful before making subsequent edits, since later changes may also need to be undone in reverse order. If you are unsure which row changed, compare the row numbers and nearby content before continuing.

For a one-off addition, inserting a row directly is usually simplest. If you need a sequence of new records, select several destination row headers at once and insert the same number of rows, or add rows within the table as needed. If you only need to move existing data down within a small area, cell insertion may be appropriate, but verify that formulas and associated columns remain aligned. For a workbook used by others, it can help to save a separate copy before making broad structural changes.

Frequently Asked Questions

How do I insert a row below the current row in Excel?
Select the row header immediately below the current row, then choose Home > Insert > Insert Sheet Rows. Excel inserts above that selected row, placing the new row below the current one.

Does Excel have an Insert Row Below button?
For worksheet rows, the usual Insert command adds rows above the selection. To get a row below a chosen row, select the next row down first. Tables provide a Table Rows Above command for the selected table row.

Can I insert several rows at once?
Yes. Select as many complete row headers as the number of rows you want to add, beginning with the row that should move down, then insert. Excel adds the same number of rows above the selection.

Why did Excel add cells instead of a whole row?
You likely selected individual cells rather than a row header, or chose an Insert Cells option. Select the numbered row header and use Insert Sheet Rows, or choose Entire row if the Insert dialog appears.

How do I add a row to the bottom of an Excel table?
Click the last cell in the table’s final row and press Tab, or use the table’s resize handle if you need to expand its range. Pressing Tab in the last table cell adds a new table row; it does not insert one in the middle.

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.