Excel Insert Row Shortcut: Windows, Mac, and More Explained

In Excel for Microsoft 365 on Windows, select the row where you want a new row, then press Ctrl+Shift++ (the plus key). For a quick keyboard-only method, press Shift+Space to select the current row, then Ctrl+Shift++ to insert a blank row above it.

The fastest way to insert a row in Excel

The shortcut works on the selected row or rows: Excel inserts new worksheet rows above the selection. On a typical US keyboard, the plus sign shares the equals key, so press Ctrl+Shift+= to produce the plus sign. On a keyboard with a separate numeric keypad plus key, Ctrl++ may also work. The exact keystroke can vary with keyboard layout, but the operation is the same: hold Ctrl and Shift, then press the key that enters a plus sign.

To insert a row without touching the mouse:

Click a cell in the row that should move down, or use the arrow keys to reach a cell in that row.
Press Shift+Space to select the entire worksheet row.
Press Ctrl+Shift++ to add a blank row above it.

For instance, if the current records are in rows 2 through 10 and you select row 6, the inserted blank row appears at row 6; the old row 6 and the rows below it move down. Selecting an entire row first matters: when only a cell is selected, Excel may show the Insert dialog so you can choose whether to shift cells down, shift cells right, insert an entire row, or insert an entire column.

Selecting the right row before inserting

The shortcut inserts relative to the selection, so the main decision is where to select. Excel places the new row above the selected row, not below it. To add a row between rows 8 and 9, select row 9 and insert. To add one at the top of a data list that begins in row 2, select row 2; the new row will appear above the list.

Shift+Space selects the whole row containing the active cell. If that shortcut does not select a row, check whether the active cell is in edit mode: press Esc or Enter to leave editing, then try again. You can also click the row number at the left edge of the worksheet. To select several adjacent rows, drag across their row numbers or select the first row and Shift-click the last row number. Inserting with several whole rows selected adds the same number of new rows above the selection. For example, selecting rows 5 through 7 and inserting adds three blank rows above row 5.

You can insert at the very top of a worksheet by selecting row 1. Excel shifts existing rows down, but a worksheet has a fixed row limit, so inserting rows at the limit can cause an error if it would push populated data beyond the available grid.

Using the ribbon or right-click instead

If the key combination is awkward, the ribbon and context menu provide the same basic command. Select one or more complete row headers, then choose Home > Insert > Insert Sheet Rows. Alternatively, right-click a selected row number and choose Insert. In both cases, Excel inserts rows above the selected rows.

When only a cell is selected, the ribbon’s Insert menu can offer several choices, including inserting sheet rows, columns, or cells. Choosing a sheet-row command inserts an entire worksheet row. Right-clicking a cell and choosing Insert can instead open the Insert dialog, where you must choose Entire row if that is what you intend. These alternatives are useful when you are unsure which object is selected or when the keyboard shortcut conflicts with a keyboard layout or another application.

Inserting more than one row

Excel uses the number of selected rows to determine how many to add. To insert four blank rows above row 12, select four whole rows beginning at row 12, then use the shortcut or ribbon command. You do not need to repeat the shortcut four times. The existing row 12 and the rows below it move down together.

For a larger insertion, select the row headers with the mouse, or enter a range in the Name Box to select the relevant rows. For example, entering 12:15 in the Name Box selects rows 12 through 15; inserting then adds four rows above row 12. Confirm the selected range before inserting, especially on a large sheet, because selecting complete rows affects the whole worksheet, not only the visible columns containing data.

What happens to data, formulas, and formatting

Inserting a worksheet row does not simply overwrite the selected row. Excel shifts existing content downward and adjusts many formulas and references to account for the change. If a formula sums a range and you insert a row within that range, Excel will often expand the range appropriately. However, formulas, charts, named ranges, external links, and references in other workbooks can behave differently depending on how they were created. After inserting rows in a complex workbook, review important calculations and linked reports rather than assuming every dependent item updated as intended.

Excel commonly carries formatting into the new row based on nearby rows. A small Insert Options button may appear beside the inserted area, allowing you to choose how the new rows are formatted, such as matching the formatting above or below, or clearing the formatting. The available choices depend on the surrounding cells. To remove unwanted formatting later, use Home > Clear > Clear Formats on the new row; this clears formatting without deleting its contents, though a newly inserted row is usually blank to begin with.

When the data is an Excel table, consider inserting a table row rather than treating the sheet as an unstructured grid. Click a cell in the table and use the table’s insert options, or right-click a table cell and choose an insert command such as Insert > Table Rows Above when that option is shown. A table row is part of the structured data area and can inherit table formatting and calculated-column behavior. By contrast, inserting an entire worksheet row changes the worksheet grid and may affect content elsewhere in that row.

Windows, Mac, and Excel for the web

The main instructions above are for Excel for Microsoft 365 on Windows. On a Mac, select the row and use the corresponding Control-Shift-plus shortcut where supported by the keyboard layout; pressing Shift+Space first is also a way to select the current row. Mac keyboards and regional layouts can make the plus key combination less obvious, and Command is not always interchangeable with Control for Excel shortcuts. If the shortcut does not behave as expected, use Home > Insert on the ribbon or the row-header context menu.

Excel for the web runs in a browser, where some keyboard shortcuts can be affected by browser or operating-system commands. The row-header right-click menu or Home > Insert > Insert Sheet Rows is a dependable alternative. In any version, check that you selected the row header rather than a single cell if you want a whole worksheet row without an Insert dialog.

Common shortcut problems and fixes

The Insert dialog appears: You likely selected a cell rather than a complete row. Choose Entire row in the dialog, or cancel, press Shift+Space, and retry the shortcut.
The shortcut types a plus sign or does something else: Make sure the worksheet is active and you are not editing a cell. Try the keyboard’s actual plus-key combination; on a US layout, plus is usually Shift and equals.
A row appears in the wrong place: Excel inserts above the selected row. Undo immediately with Ctrl+Z if appropriate, then select the row that should move down and insert again.
Only part of the data seems to move: You may have inserted cells rather than an entire sheet row, or the data may be in a table with its own row structure. Undo if needed, select the row number, and choose Insert Sheet Rows.
The new row has unexpected formatting: Use the Insert Options button if it appears, or clear the new row’s formatting. Check nearby merged cells as well; merged layouts can make inserting cells or rows behave less intuitively.

When you are unsure what will move, save the workbook or use Undo promptly after an unexpected result. Ctrl+Z reverses a recent insertion in a normal editing session, but it is not a substitute for checking the selected range before making structural changes in a shared or complicated workbook.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
On Windows, select the row and press Ctrl+Shift++ (on many US keyboards, Ctrl+Shift+=). If a cell is active, press Shift+Space first to select its entire row.

Does Excel insert a row above or below the selected row?
Excel inserts above the selected row. To place a blank row between two existing rows, select the lower of the two and insert.

How do I insert multiple rows at once?
Select the same number of complete row headers as the number of rows you want, then use the insert shortcut or Home > Insert > Insert Sheet Rows. The new rows appear above the selected range.

Can I insert a row with only the keyboard?
Yes. Move to a cell in the target row, press Shift+Space to select the row, then press Ctrl+Shift++ on Windows. The ribbon is another option if your keyboard layout makes the plus shortcut difficult.

Why does Ctrl+Shift++ open a dialog instead of inserting a row?
Excel may have only a cell selected. The dialog lets you choose what to insert. Select Entire row there, or cancel and select the row with Shift+Space before pressing the shortcut again.

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.