Excel Shortcut for Inserting a Row on Windows and Mac

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the row where the new one should go with Shift+Space, then press Ctrl+Shift+= (the key that types +). Excel inserts a blank row above the selected row. On a keyboard with a separate plus key, Ctrl++ expresses the same shortcut; the ribbon alternative is Home > Insert > Insert Sheet Rows.

The Windows shortcut and what it does

The shortcut has two parts: select a whole worksheet row, then issue the insert command. Shift+Space selects the row containing the active cell. Ctrl+Shift+= inserts a new row above that selection. If a complete row is selected, Excel can insert immediately; if only a cell or range is selected, Excel may show an Insert dialog so you can choose whether to shift cells down or insert an entire row.

On many keyboards, the plus sign shares a key with the equals sign. In that case, hold Ctrl and Shift and press =. The shortcut is often written as Ctrl+Shift+Plus or Ctrl++. These notations refer to the plus operation, not to pressing two plus keys. A dedicated numeric-keypad plus key may work with Ctrl and without Shift.

The row is inserted above the selected row, not below it. For example, if the active cell is B6, Shift+Space selects worksheet row 6; the insert command creates a new, blank row 6 and moves the former row 6 and the rows beneath it down one position.

Insert a row step by step

  1. Click a cell in the row that should move down. It can be any cell in that row.
  2. Press Shift+Space to select the whole worksheet row. The row number at the left should highlight.
  3. Press Ctrl+Shift+=. The new row appears above the selected row.
  4. Enter data in the new row, or paste the information you need into it.

For example, to add a record between rows 12 and 13, click a cell in row 13, select the row with Shift+Space, and use the insert shortcut. The new empty row becomes row 13, and the old row 13 shifts down to row 14. This method is useful when the row should be inserted into the worksheet rather than merely adding an empty cell inside a table of existing cells.

Insert several rows at once

You can insert multiple adjacent rows in one operation. Select the same number of existing rows as the number of blank rows you want. For example, to add three rows above row 10, select rows 10 through 12, then press Ctrl+Shift+=. Excel inserts three rows above the selection. The selected rows themselves move down; their contents are not deleted.

To select a block, click the first row number and drag down to the last, or click the first row number, hold Shift, and click the last row number. You can also select a row with Shift+Space, then extend the selection with Shift and the Up or Down arrow keys. Check that the intended number of full row headers is highlighted before inserting, especially if the worksheet contains important data nearby.

Inserting several rows together is generally clearer than repeating the command one row at a time. It preserves the intended position and makes the number of added rows easy to verify. If you need a single row in several different locations, select each target position separately and insert there.

What happens to existing data and formatting

When you insert an entire worksheet row, Excel shifts existing cells in that row and below it downward. It does not overwrite the values that were already in the selected row. Formulas that refer to shifted cells are typically adjusted by Excel so their references continue to point to the relevant cells, but always review formulas when the structure of a complex workbook changes. Insertion can affect named ranges, charts, pivot-table source ranges, and other dependencies differently depending on how they were set up.

The new row’s appearance may follow nearby formatting. Excel can offer an Insert Options button after the operation, allowing you to choose formatting such as matching the row above or below, or clearing formatting. The exact available choices can depend on the surrounding cells and whether the data is in an Excel table. Inserting a row does not automatically mean that every formula, validation rule, or custom format you expect will be present, so inspect the new row before relying on it.

There is also a difference between inserting a worksheet row and inserting cells. If you select only a cell and use the insert command, Excel may ask whether to shift cells right, shift cells down, insert an entire row, or insert an entire column. Choosing an entire row affects the whole worksheet width. That distinction matters when columns contain separate data that must remain aligned.

Use the ribbon or row-header menu

If the keyboard shortcut is awkward, or if you want a visible command, use the ribbon. Select a cell in the target row, then choose Home > Insert > Insert Sheet Rows. Excel inserts a row above the active cell’s row. For multiple rows, select multiple rows first; the command inserts the matching number.

You can also right-click the row number at the left edge of the worksheet and choose Insert. This is a convenient option when you are already using the mouse. Right-clicking a cell within the grid can show a different context menu, so choosing the row header is the more direct way to make clear that you intend to insert a full row.

These methods perform the same basic worksheet operation. The ribbon is easier to discover, the row-header menu makes the target visible, and the keyboard shortcut is usually quickest once you know it. Use whichever method best suits the task; choosing a different interface does not change where the new row is placed.

Excel for Mac and Excel for the web

In Excel for Mac, select the target row with Shift+Space, then use Control+Shift+= to insert a row above it. Keyboard behavior can vary with the keyboard layout, so if the plus key is not recognized, use the menu instead: select the row and choose the insert-row command from Excel’s menu or context menu. Avoid assuming that the Windows Ctrl shortcut is interchangeable with Command on a Mac; Excel’s documented insert shortcut uses Control.

Excel for the web runs in a browser, where browser and operating-system shortcuts can sometimes take precedence. Try the keyboard combination if it works in your setup, but use the ribbon when the shortcut is intercepted: select the row and choose Home > Insert > Insert Rows. The wording and available commands can vary slightly with the web interface. The row-header right-click menu is another practical option.

On any platform, selecting the row first is the dependable part of the process. It makes the intended operation unambiguous and avoids the cell-shift choices that can appear when only a small range is selected.

Common shortcut problems

  • The plus key does not work: On a standard keyboard, plus is commonly typed with Shift and the equals key. Hold Ctrl and Shift together, then press =. On some layouts, use the dedicated plus key or insert through the ribbon.
  • Excel opens an Insert dialog: This can happen when a cell or cell range is selected rather than a full row. Choose Entire row, or press Esc and select the row first with Shift+Space.
  • The row appears in the wrong place: Excel inserts above the selected row. Select the row that should move down, not the row that should remain above the new blank one.
  • Only cells shift, rather than the whole row: Make sure the row number is selected. A cell selection can invoke an insert-cells action instead of inserting a worksheet row.
  • The shortcut is intercepted: This is more likely in a browser or with certain keyboard layouts. Use Home > Insert > Insert Sheet Rows, or right-click the row header and choose Insert.

If insertion fails, check whether the worksheet is protected or whether Excel has reached the worksheet’s row limit. A worksheet supports up to 1,048,576 rows; if the last row already contains data that would need to shift beyond that limit, Excel cannot insert another full row. A protected sheet may also restrict structural changes unless the appropriate permissions are available.

Rows inside an Excel table

A formatted Excel table has its own structure, which can make inserting data feel different from inserting an ordinary worksheet row. To add a record at the end of a table, click the last cell in the last table row and press Tab; Excel creates a new table row. Typing directly into the row immediately below a table can also cause Excel to expand the table in many cases, depending on its settings and surrounding content.

To add a row within the table, select a cell in the table row where the new record belongs and use the table’s insert options, or right-click a table row and choose an insert command. Inserting a full worksheet row with the row header affects the entire sheet, not just the table. This may be exactly what you want when other columns must stay aligned, but for a table-only change, use the table context menu and check that the new row is part of the table afterward.

Choosing the right insertion method

Use the keyboard shortcut when you know the target location and want to add one or more complete worksheet rows quickly. Use the ribbon or row-header context menu when you are unsure which range is selected, are working on a different keyboard layout, or want an obvious command. Use table-specific insertion or Tab when the goal is to extend a structured table rather than alter the worksheet grid more broadly.

Before making a structural change in a workbook with linked calculations, consider saving the file or confirming that the change is easy to reverse. Ctrl+Z usually undoes a recent insertion in desktop Excel, but some operations or later actions can affect the available undo history. For a critical workbook, check affected formulas, table boundaries, and charts after inserting rows.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
Select the row with Shift+Space, then press Ctrl+Shift+= on a typical Windows keyboard. This inserts a blank row above the selected row. A dedicated numeric-keypad plus key may work as Ctrl++.

How do I insert a row above the current row?
Click any cell in the row that should move down, select the whole row, and run the insert command. Excel places the new row above the selected row, so selecting row 8 creates a new row 8.

How do I insert multiple rows in Excel?
Select the same number of existing rows as the number you want to add, then use the insert shortcut or Home > Insert > Insert Sheet Rows. Selecting four rows and inserting adds four blank rows above them.

Why does Excel show an Insert dialog instead of adding a row?
Excel may show the dialog when only cells are selected. Select a complete row first with Shift+Space, or choose Entire row in the dialog to insert across the worksheet.

What is the row-insert shortcut on a Mac?
In Excel for Mac, select the row with Shift+Space and press Control+Shift+=. If that combination is inconvenient or behaves differently with your keyboard layout, select the row and use the insert command in Excel’s menu.

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.