Excel Shortcut to Insert an Entire Row

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the row where the new row should go, then press Ctrl+Shift++ (usually typed as Ctrl+Shift+=, because the plus sign shares the equals key). Excel inserts a full worksheet row above the selected row. If you have selected only a cell, the shortcut opens the Insert dialog; choose Entire row there.

The Windows shortcut and what it does

The shortcut uses Ctrl, Shift, and the plus sign. On a standard keyboard, press and hold Ctrl and Shift, then press the key marked = and +. On a keyboard with a separate numeric keypad, Ctrl plus the keypad’s + key may also work. Excel’s response depends on what is selected: a full row selection tells Excel to insert a row immediately, while a cell selection requires you to specify what to insert.

The new row appears above the selected row. For example, if row 8 is selected, the blank row is inserted at row 8 and the old row 8 moves down to row 9. This is useful when you need to add a record in the middle of a list without replacing or clearing the data already there.

Select the row before using the shortcut

To select a complete worksheet row without reaching for the mouse, click a cell in the row and press Shift+Space. Then press the insert shortcut. The row selection is important: it makes your intention clear to Excel and avoids opening the dialog with choices for shifting cells.

  1. Click any cell in the row where the new row should appear.
  2. Press Shift+Space to select the entire worksheet row.
  3. Press Ctrl+Shift++ (often entered as Ctrl+Shift+=).
  4. Check that the blank row has appeared above the row you selected.

You can also select a row by clicking its numbered header at the far left of the worksheet. The header changes appearance when the entire row is selected. If you select several adjacent row headers, the shortcut inserts the same number of rows above the selection. For instance, selecting rows 8 through 10 and inserting creates three new rows above row 8.

What happens when you select only a cell

If a single cell is active rather than a whole row, Excel cannot assume that you want to add a worksheet row. The shortcut opens the Insert dialog, which can offer choices such as shifting cells right, shifting cells down, inserting an entire row, or inserting an entire column. Choose Entire row and confirm. This inserts a worksheet row above the active cell’s row, not merely a blank cell in that column.

This distinction matters in a structured range. Suppose a cell in column C is selected and you choose to shift cells down: only the selected cells in that column may move, leaving neighboring data out of alignment. Choosing Entire row instead moves the worksheet’s contents below the insertion point down together. If the goal is a new record across a list, insert a whole row rather than shifting cells in one column.

Insert several rows at once

For a batch of new rows, select as many existing rows as you want to add, then use the same shortcut. Excel inserts that number of rows above the first selected row. Selecting four row headers, for example, and pressing the shortcut creates four blank rows; you do not need to repeat the command four times.

When selecting with the keyboard, select a row with Shift+Space, then extend the selection to neighboring rows using the selection keys. With the mouse, drag over the row-number headers or select the first row and Shift-click the last row in the range. Keep the rows adjacent for a predictable insertion. If you need to add rows in separate places, do each insertion at its own location and check the surrounding records as you go.

Adding a block is especially handy when importing or entering a set of new transactions, inventory items, or survey responses. It also gives you a chance to copy formatting into the new area afterward. Excel may carry formatting from nearby rows into inserted rows, but verify number formats, borders, validation rules, and formulas before filling in important data.

Other ways to insert an entire row

The keyboard shortcut is not the only method. These options are useful when you forget the key combination or when a keyboard layout makes the plus key awkward:

  • Ribbon: Select a cell in the target row, then choose Home > Insert > Insert Sheet Rows. This inserts a complete worksheet row above the active row.
  • Row header menu: Right-click the row number and choose Insert. If several row headers are selected, Excel inserts that many rows.
  • Cell context menu: Right-click a cell, choose Insert, and select Entire row in the dialog.
  • Touch or accessibility workflows: Use the ribbon command when pressing a multi-key shortcut is inconvenient. The command makes the operation explicit and is easier to locate by name.

The row-header menu is often the clearest mouse option because the selection already represents a whole row. The ribbon command is useful when you want to avoid a context menu or need a visible command path to explain to a colleague.

Excel on Mac and in a web browser

On Excel for Mac, the insert-row shortcut is generally Control+Shift+= (the plus sign on many keyboards). Mac keyboard layouts and external keyboards can differ, so if that combination does not work, select the row and use Home > Insert > Insert Sheet Rows or the row-header context menu. Do not assume that the Windows Ctrl shortcut becomes Command: Excel uses Control for this insertion command on Mac.

In Excel for the web, browser and keyboard settings can affect shortcut behavior. Select the row header and try the displayed Excel shortcut if it is available in your environment; otherwise, use Home > Insert > Insert Rows or the row-header menu. The ribbon is a dependable fallback when the browser intercepts a key combination or the keyboard does not have a familiar plus key.

Shortcut labels and menus can vary slightly by platform and release. The underlying operation is the same: select the row at the insertion point and insert a sheet row above it. If you are following instructions written for another platform, use the ribbon path or context menu to confirm that you are inserting a full row, not shifting a small group of cells.

Common problems and how to fix them

  • The shortcut types a plus sign instead: Make sure Excel has focus and that you are holding Ctrl and Shift while pressing the plus key. On many keyboards, the plus key is the Shift version of =. A separate keypad plus may be easier.
  • The Insert dialog appears: You likely selected a cell, not the row. Choose Entire row, or cancel, press Shift+Space, and repeat the shortcut.
  • A row was added in the wrong place: Excel inserts above the selected row. Undo immediately with Ctrl+Z on Windows, then select the row below the intended insertion point and try again.
  • The Insert command is unavailable: The worksheet may be protected, or the workbook may restrict structural changes. Check Review > Unprotect Sheet if you have permission and the sheet is protected. In a shared or restricted workbook, ask its owner about the allowed edits.
  • Only one row was inserted: Before pressing the shortcut, confirm that all intended row headers are selected. Selecting cells across multiple columns does not necessarily mean you selected multiple complete rows.

Be especially careful in worksheets with merged cells or protected ranges. Excel can prevent a row insertion when it would disrupt merged areas or when protection settings disallow it. If the command fails, do not repeatedly try different insertion methods without checking the worksheet’s structure; first identify whether the sheet is protected or contains a layout constraint.

Effects on formulas, tables, and formatting

Inserting a worksheet row usually shifts existing cells below the insertion point down. Excel adjusts many ordinary cell references when rows are inserted, so formulas that refer to affected cells commonly continue to point to the intended data. However, inspect formulas around the insertion point, especially if they use fixed ranges, external references, named ranges, or logic that assumes a specific row count. A worksheet change can affect a report even when no error appears.

If the data is formatted as an Excel Table, distinguish inserting a sheet row from adding a table record. A table can expand as data is entered in the row directly beneath it, and its own row-insertion options may be available from the table context menu. Inserting a whole worksheet row through the row header changes the sheet grid and may affect other content on that row. For a simple new table record, adding a row within or directly below the table is often the more focused operation.

Excel may copy formatting from adjacent rows into a newly inserted row. That can be convenient, but it is not a guarantee that every detail is right. Check date and currency formats, conditional formatting, data validation, formulas, and table banding. If an inserted row inherits an unwanted appearance, use the insert options button that appears nearby, when available, to choose an appropriate formatting option.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
On Windows, select the row and press Ctrl+Shift++, usually typed as Ctrl+Shift+=. Excel inserts a worksheet row above the selection.

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

Can I insert multiple rows with one shortcut?
Yes. Select the same number of adjacent row headers as the number of rows you want, then press the insertion shortcut once. Excel adds that many rows above the selected block.

Why does Ctrl+Shift++ open a dialog?
That normally means a cell, rather than an entire row, is selected. Choose Entire row in the dialog, or press Shift+Space first to select the row.

What is the Mac shortcut for inserting a row?
Excel for Mac generally uses Control+Shift+=. Keyboard layouts differ, so selecting the row and using Home > Insert > Insert Sheet Rows is a reliable alternative.

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.