Excel Insert Row Below a Selected Row: Quick Steps

How-to basics · Updated November 19, 2026

To insert a worksheet row below the row you selected in Excel, select the row header immediately underneath it, then choose Home > Insert > Insert Sheet Rows. Excel inserts rows above the selected row, so selecting the next row is the key: if row 8 is selected, select row 9 before inserting.

Why Excel inserts above the selection

Excel’s standard insert command places new cells, columns, or rows before the current selection. That behavior is consistent across the ribbon and the usual keyboard shortcut, but it can feel counterintuitive when you want to add space underneath a particular row. Excel does not need a separate command called “insert below”: you identify the position by selecting the row that should come after the new one.

For example, to add a blank row between rows 8 and 9, select row 9 and insert a sheet row. The existing row 9 moves down, and the blank row takes its place. To add a blank row at the bottom of a list ending in row 25, select row 26 and insert; the new row appears between the old data and whatever was below it.

This distinction matters because selecting row 8 and using Insert Sheet Rows adds a row above row 8, not below it. If you have selected a cell rather than a row header, Excel may offer choices for inserting cells or may infer what to insert from the selection. Selecting the row header makes the intended operation clear.

Insert a row below using the ribbon

  1. Find the row number directly below the row where you want the blank row. Row numbers appear along the left edge of the worksheet.
  2. Click that row number to select the entire row. For example, click the 9 header to insert beneath row 8.
  3. On the ribbon, choose Home > Insert > Insert Sheet Rows. In some window sizes, Insert is shown as a dropdown in the Cells group.
  4. Check the result: the selected row should move down, leaving a new blank row above it and below the row you originally targeted.

You can also right-click the row number below the intended insertion point and choose Insert. When an entire worksheet row is selected, this inserts a worksheet row above it. The ribbon command is useful when you want to follow a visible sequence of steps; the context menu is often quicker when your pointer is already at the row headers.

Use a keyboard shortcut

In Excel for Microsoft 365 on Windows, select the row header below the desired position and press Ctrl+Shift+=. On a standard keyboard, the plus sign shares the equals key, which is why the shortcut is often described as Ctrl plus. The shortcut inserts above the selection, so selecting the next row first remains essential. If the row itself is not selected, Excel may open an Insert dialog for cells instead of inserting a whole worksheet row.

Keyboard layouts and laptop keyboards can make the plus-key combination awkward. If it does not work as expected, select the row header and use Home > Insert > Insert Sheet Rows instead. Excel for Mac has different keyboard conventions and system-level shortcut variations; the reliable menu route is to select the next row and use Home > Insert. You can also use the row-header context menu, usually with a Control-click or a two-finger click depending on your Mac’s settings.

Excel for the web also supports inserting worksheet rows through the ribbon and row-header context menu. Its available keyboard shortcuts can depend on the browser and keyboard, so use the visible Insert command if a shortcut is intercepted or behaves differently.

Worksheet rows and Excel table rows are different

A worksheet row stretches across the sheet and has a numbered header. An Excel table is a formatted data range with its own table headers, filters, and structured references. If your selected row is inside a table, inserting a full worksheet row can affect cells outside the table as well. For an ordinary addition to the table’s records, use the table-specific option instead.

To add a table row below a particular table record, select a cell in the table row immediately below the intended position, right-click, and choose Insert > Table Rows Above if that option is available in the context menu. The new table record appears above that selected record. The wording may vary slightly with the selection and Excel version, so confirm that the command refers to table rows rather than entire sheet rows.

For a new record at the end of a table, another practical method is to click the last cell in the table’s final row and press Tab. Excel moves to a new row and expands the table. This is convenient when you are entering a record, but it is not the same as inserting a blank worksheet row underneath the table. If you need empty space outside the table, select the worksheet row below the table and insert a sheet row.

What happens to data, formatting, and formulas

Inserting a worksheet row shifts existing cells below the insertion point downward. It does not simply overwrite the next row. The inserted row is typically formatted to match nearby cells, but the exact result can depend on adjacent formatting and the workbook’s styles. After inserting, check number formats, borders, fills, and row height if the new line needs to match a specific part of the sheet. The Insert Options button that may appear near the new row can offer formatting choices, such as matching the formatting above or below.

Excel generally adjusts cell references in formulas when rows are inserted, which helps formulas continue to refer to the intended data. However, do not assume every dependent item will update exactly as you want. Formulas containing hard-coded row numbers, text-based references, or functions such as INDIRECT may behave differently from ordinary cell references. Charts, named ranges, external links, and other workbook features can also deserve a quick review, particularly in a complex file.

Before making a structural change to an important workbook, save it or create a copy. Then inspect a few relevant formulas and totals after inserting. This is especially useful in reports where a subtotal or summary formula sits near the insertion point, or where neighboring rows have different meanings, such as a heading followed by detail records.

Insert more than one row below

You can insert several blank rows at once. Select the same number of row headers immediately below the intended position, then use Home > Insert > Insert Sheet Rows or the keyboard shortcut. Excel inserts one row for each row header selected. For instance, if you want three blank rows below row 8, select row headers 9, 10, and 11, then insert. The three selected rows move down, and three blank rows appear before them.

To select a continuous range, click the first row header and drag through the others, or click the first header, hold Shift, and click the last header. For nonadjacent rows, Ctrl-clicking headers may select separate rows on Windows, but inserting with noncontiguous selections can be less predictable for the layout you want. A continuous selection is the clearer option when the goal is a block of consecutive blank rows.

For a large number of rows, select the required range of row headers before inserting rather than repeating the command many times. Verify the selected range before you act: the number of highlighted row headers determines how many rows Excel adds.

Common problems and how to fix them

  • The row appeared above the wrong line: Excel inserts above the selection. Undo with Ctrl+Z on Windows, select the row header below the intended gap, and insert again.
  • Only some cells moved: You may have selected cells rather than a row header and inserted cells. Undo, click the numbered row header, and use Insert Sheet Rows.
  • The Insert command is unavailable: The worksheet may be protected, or the workbook may have restrictions on structural changes. Check the Review tab for protection controls, and follow the workbook owner’s instructions before changing protection.
  • The new row does not appear in the filtered list: Filters can hide records that do not meet the current criteria, and a newly inserted row may not be visible in the filtered view. Review the filter or clear it temporarily, then confirm where the row was inserted.
  • The row looks different from nearby rows: Use the Insert Options control if shown, or copy the desired formatting from a neighboring row. Check row height and number formats as well as color and borders.
  • Excel refuses to insert because of merged cells: Merged ranges can interfere when their shapes do not line up with the insertion. Review the merged cells around the insertion point; unmerging or adjusting the layout may be necessary.

If you are working near hidden rows or a filtered range, take a moment to identify the actual row numbers before inserting. A row can be directly below the visible row while not being the next worksheet row number. Selecting the numbered header for the row you want Excel to move down avoids that ambiguity.

When to use an alternative

Use Insert Sheet Rows when you need a whole blank worksheet row, including space across columns that may contain data beyond your visible list. Use table-row insertion when you are adding a record inside a formatted Excel table and want the table to expand as a table. Use Tab from the last table cell when entering a new record at the bottom is more important than leaving an empty row.

If you only need to shift a small block of cells, select that block rather than inserting a full worksheet row. Excel’s Insert command can offer options to shift selected cells right or down, but those choices can misalign data if neighboring columns are part of the same records. For tabular information, moving an entire row or adding a table row is usually safer than shifting just one column’s cells.

Also consider whether a blank row is needed at all. In a dataset used for sorting, filtering, or a PivotTable, blank rows inside the data can sometimes interrupt the contiguous range Excel recognizes. An Excel table can provide a cleaner way to add records without relying on blank separators. For a presentation-style worksheet, by contrast, a blank row may be useful for visual spacing.

Frequently Asked Questions

How do I insert a row below row 5 in Excel?
Select the row 6 header, then choose Home > Insert > Insert Sheet Rows. Excel inserts above row 6, which places the new row below row 5.

Can I insert a row below the selected row with one click?
Not by selecting the target row and using the standard Insert command, because that command inserts above the selection. Select the next row first, then use Insert.

What is the shortcut to insert a row in Excel?
On Windows, select a full row and press Ctrl+Shift+=. To put the new row below a target row, select the row beneath the target before using the shortcut.

How do I insert multiple rows below a row?
Select the same number of row headers below the target as the number of blank rows you need, then choose Home > Insert > Insert Sheet Rows. A selection of three row headers inserts three rows.

Does inserting a row change formulas?
Excel usually adjusts ordinary cell references when rows are inserted, but hard-coded row references and some indirect references may not behave as intended. Review important formulas, totals, and charts after a structural change.

How do I add a row below a row in an Excel table?
Select the table row that should follow the new record, then use the table-row insertion option, such as Insert > Table Rows Above in the context menu. To add a record at the end, press Tab from the table’s last cell.

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.