Excel Insert Row Below Shortcut on Windows and Mac

In Excel for Microsoft 365 on Windows, select the worksheet row directly below where you want the new row, then press Ctrl+Shift+= (the plus-key shortcut). Excel inserts a blank row above the selected row, which places it below the row you wanted to keep above it. On a US keyboard, the plus sign is usually made with Shift and the equals key.

Quick answer: insert a row below

Excel’s insert-row command inserts rows above the current selection; it does not have a separate command that inserts a worksheet row underneath the selection. To put a blank row below row 8, select row 9 and use the shortcut. The new row becomes row 9, and the original row 9 and everything beneath it move down.

For the most direct keyboard sequence on Windows:

Click any cell in the row immediately below the desired insertion point. For example, click a cell in row 9 to add a row below row 8.
Press Shift+Space to select the entire worksheet row.
Press Ctrl+Shift+= to insert a blank row above that selected row.

Selecting the whole row first matters: it tells Excel to insert a complete worksheet row without asking what kind of cells to insert. If you select only a cell, Excel may open the Insert dialog instead.

Why Excel inserts above the selection

Excel’s standard insert command works relative to the selected cells. When you select a row and insert, the new row appears above it, pushing the selected row and the rows below it downward. That behavior is consistent with inserting cells: Excel needs to know which existing cells should move to make room.

Think of the selection as the boundary marker. If the new row should sit between rows 8 and 9, select row 9 before inserting. Selecting row 8 instead puts the blank row between rows 7 and 8. This is the main detail behind the common search for an insert-below shortcut: the shortcut is the same, but you select the row beneath the intended location.

The command adds space; it does not replace the selected row or erase its contents. Data in the affected rows shifts down, and Excel normally adjusts formulas and references that point to moved cells. Still, inserting a row can affect layouts, charts, print areas, and formulas that depend on fixed positions, so check the surrounding sheet after a large structural edit.

Selecting a row before using the shortcut

You can select a row with the keyboard or the mouse. The keyboard sequence Shift+Space selects the entire row containing the active cell. Alternatively, click the row number at the left edge of the worksheet. Once the row is highlighted, use the insert shortcut. This method is useful when you are editing a long sheet and want to keep your hands on the keyboard.

For example, suppose a list has headers in row 1 and entries in rows 2 through 20. To create a blank line between entries currently in rows 10 and 11, select row 11 and insert. The old row 11 becomes row 12, and the new empty row is 11. If you need the blank line after the final entry in row 20, select row 21 and insert; Excel creates a new row 21.

Row numbers can be used to select more than one row at once. Drag down the row headings or select a row and extend the selection with the keyboard. Inserting with several complete rows selected adds the same number of blank rows above the selection. This is usually quicker and more predictable than repeating the command one row at a time.

What the shortcut does with a cell selected

If you press Ctrl+Shift+= while only one cell is selected, Excel may display the Insert dialog rather than immediately inserting an entire row. The dialog offers choices such as shifting cells right, shifting cells down, inserting an entire row, or inserting an entire column. Choose Entire row and confirm to add a worksheet row above the row containing the selected cell.

That dialog is useful when you want to make room for a few cells without shifting a whole worksheet row. For the ordinary task of adding a row across the sheet, select the row first with Shift+Space or click its row number. The command then has an unambiguous selection and can insert the full row directly.

On many keyboards, the plus sign is typed by holding Shift while pressing the equals key, which is why the Windows shortcut is commonly written as Ctrl+Shift+=. If your keyboard has a separate numeric keypad plus key, the physical key combination can differ; use the plus key indicated by your keyboard layout. The goal is the Insert command, not a particular printed symbol on the keycap.

Adding several rows at once

To add multiple blank rows, first select the same number of existing rows as the number you want to insert, beginning with the row that should move down. Then run the insert shortcut once. For instance, to insert three rows between rows 8 and 9, select rows 9, 10, and 11, then insert. Excel adds three blank rows starting at row 9 and moves the selected data downward.

Check that the selection covers complete rows and the correct count before using the command. If you select three cells rather than three row headings, Excel may insert cells and ask how to shift neighboring data instead. For large insertions, the Name Box to the left of the formula bar can help select a range such as 9:11; after entering the row range, press Enter, then use the insert shortcut.

Using the shortcut in an Excel table

A formatted Excel table has its own structure, including a header row, filter buttons, and automatic expansion when data is entered directly below it. The worksheet-row shortcut can still be useful when inserting within a table, but table boundaries can affect what Excel adds and how formatting or calculated columns fill into the new space.

For an explicit table-row insertion, right-click a cell in the table row and choose Insert, then Table Rows Above. This makes the intention clear when you want another record within the table. If the goal is simply to add a record at the end, entering data in the row directly beneath the table often expands the table automatically. Check that the new record is included in the table’s filters and formulas rather than merely sitting below it.

Windows, Mac, and Excel for the web

On Excel for Microsoft 365 on Windows, use Shift+Space to select the row, followed by Ctrl+Shift+= to insert above it. Ribbon users can select the target row and choose Home > Insert > Insert Sheet Rows. This menu route is a reliable fallback if a keyboard layout, remote desktop, or another application interferes with a shortcut.

In Excel for Mac, select the row below the intended location and use Control+Shift+= where supported by the keyboard layout. The exact key combination can be affected by the Mac keyboard and system shortcuts, so use Home > Insert > Insert Sheet Rows if the shortcut is unavailable. The central rule is unchanged: select the row that should move down, because Excel inserts above the selection.

Excel for the web has a similar row-insertion command, but browser and operating-system shortcuts can sometimes take precedence. If the keyboard combination does not work in the browser, select the row heading and use the Insert command on the Home tab or the row’s context menu. The menu is also useful when you are unsure whether Excel has selected a cell, a table row, or a complete worksheet row.

Common problems and how to fix them

The shortcut opens a dialog: You probably selected a cell rather than the whole row. Choose Entire row in the dialog, or cancel, press Shift+Space, and repeat the shortcut.
The wrong place gets a blank row: Remember that Excel inserts above the selected row. Undo immediately with Ctrl+Z if appropriate, then select the row below the intended position and try again.
The shortcut does nothing: Check that Excel has focus and that the worksheet is not protected against row insertion. Try the Home tab’s Insert Sheet Rows command to see whether the issue is the key combination or a worksheet restriction.
Excel reports that it cannot shift cells: Content or formatting near the bottom or edge of the sheet can prevent cells from moving. Review the affected area and remove only genuinely unnecessary content or formatting; do not clear data simply to force the insertion.
Rows look different after insertion: Excel may carry formatting from a neighboring row. Look for the Insert Options button near the new row, where available, to choose an appropriate formatting option, or copy the desired format from a nearby row.

Merged cells and protected worksheets can also make row operations behave unexpectedly or prevent them altogether. If a sheet is protected, the owner may need to allow row insertion or unprotect it before you can proceed. On a filtered list, distinguish between a worksheet row and a visible record: inserting a whole worksheet row affects the sheet’s row structure, including rows that may currently be hidden by a filter.

Keyboard shortcut or ribbon command?

The shortcut is fastest when you know which row should move down and are comfortable selecting complete rows. The ribbon is easier to discover and can be clearer for occasional users. Both methods insert above the selection, so the selection rule applies regardless of how you issue the command.

Choose the method that fits the task:

One row while keyboarding: Use Shift+Space, then Ctrl+Shift+= on Windows.
Several consecutive rows: Select the required number of row headings, then insert once.
A table record: Use the table’s Insert > Table Rows Above command, or enter a record immediately below the table.
A shortcut that is unavailable: Use Home > Insert > Insert Sheet Rows.

After inserting, inspect the neighboring records and formulas. This is especially worthwhile in sheets with totals, manually maintained numbering, merged headings, or print layouts. Excel adjusts many cell references when rows move, but a manually typed label such as a sequence number may not update just because a row was added.

Frequently Asked Questions

What is the Excel shortcut to insert a row below?
There is no separate below-selection shortcut for a worksheet row. Select the row immediately below the desired location and press Ctrl+Shift+= on Windows; Excel inserts a blank row above the selection.

How do I insert a row below the current row without a mouse?
Move to a cell in the next row, press Shift+Space to select that row, and press Ctrl+Shift+=. For example, to insert below row 12, select row 13 first.

Can I insert more than one row with the shortcut?
Yes. Select as many complete rows as you want to add, starting at the row that should move down, then use the insert shortcut once. Selecting four rows inserts four blank rows above them.

Why does Ctrl+Shift+= open an Insert dialog?
Excel commonly shows the dialog when only a cell or cell range is selected. Select the full row first with Shift+Space, or choose Entire row in the dialog to insert a worksheet row.

Does the shortcut work for an Excel table?
It can, but for a clear table-specific insertion, right-click a cell in the table row and choose Insert > Table Rows Above. That command adds a table row above the selected table record.

What is the Mac shortcut to insert a row?
Excel for Mac commonly uses Control+Shift+=, though the precise key behavior can vary with the keyboard layout. If it does not work, select the row and use Home > Insert > Insert Sheet Rows.

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.