Insert Entire Row in Excel: Shortcut and Alternatives

In Excel for Microsoft 365 on Windows, select any cell in the row and press Shift+Space to select the entire worksheet row, then press Ctrl+Shift++ to insert a new row above it. On many keyboards, the second shortcut is typed as Ctrl+Shift+=, because the plus sign shares the equals key.

The shortcut and what it does

The shortcut has two parts: select the row, then insert. Shift+Space selects the whole worksheet row containing the active cell. Ctrl+Shift++ inserts a row above the selected row. The new row is blank, and existing rows below the insertion point move down. For example, if the active cell is B8, Shift+Space selects row 8; the insert shortcut then creates a blank row 8 and moves the old row 8 to row 9.

If you have already selected a complete row by clicking its row number, you can skip Shift+Space and use the insert shortcut. You can also select several adjacent row numbers first: Excel inserts the same number of rows above the selection. Selecting rows 8 through 10 and inserting therefore creates three blank rows above the former row 8.

The shortcut inserts worksheet rows, not just blank cells in a few columns. That distinction matters when the sheet has data in columns beyond the ones currently visible. A worksheet row extends across all of its columns, so inserting a whole row shifts the existing content below it throughout the sheet.

How to insert a row step by step

Click a cell in the row where the new row should go. To place a row between rows 7 and 8, click any cell in row 8.
Press Shift+Space. Confirm that the row is selected across the worksheet; its row number should be highlighted.
Press Ctrl+Shift++. On a standard US keyboard, hold Ctrl and Shift and press the key that produces +, often the = key.
Check the insertion point and nearby data. The blank row should appear above the row you selected.

There is also a mouse method: right-click the selected row number and choose Insert. Or use the ribbon path Home > Insert > Insert Sheet Rows. These options are useful if the keyboard shortcut is intercepted by a laptop keyboard, remote desktop, or another application. They also make it easier to confirm that you are inserting a whole sheet row rather than shifting selected cells.

Choosing the right row selection

Excel uses the selection to decide both where and how many rows to add. A single selected row gives you one new row above it. If you select three adjacent row headers, Excel adds three rows above the first selected row. You do not need to select blank rows first; selecting the target row or rows is enough.

For example, to add two blank rows between a heading in row 4 and the records that begin in row 5, select row headers 5 and 6, then insert. The old records move down by two rows. If you select a cell range such as B5:D6 instead of complete rows, Excel may show an Insert dialog and ask whether to shift cells down or shift cells right. That is a different operation and can leave unrelated columns out of alignment. Use Shift+Space or row headers when the goal is a complete worksheet row.

You can select adjacent row headers by dragging over their numbers or by selecting one row and extending the selection with Shift. To select a nonadjacent set of row numbers, use Ctrl while selecting on Windows. Be cautious with nonadjacent selections: for a straightforward block of inserted rows, a contiguous selection is clearer and less likely to produce an unintended layout.

Insert above, below, or at the bottom

The standard insert-row command places new rows above the selected row. To add one below row 8, select row 9 and insert. If row 9 contains data, that data moves down, while the new blank row occupies its former position. Excel does not offer a separate general-purpose Insert Below command for ordinary worksheet rows; choosing the row beneath your intended location is the usual approach.

At the bottom of a data list, you may not need to insert a worksheet row at all. If the data is an Excel table, typing in the row immediately beneath the table or pressing Tab from its last cell can extend the table with a new record. A table is a structured range with filter buttons and features such as automatic formatting. To add a row within the table at a particular position, right-click a cell in the table and choose Insert > Table Rows Above, where that option is available. This adds a table row and is often a better fit than inserting a whole worksheet row.

When working with a normal range rather than a table, the whole-row shortcut is appropriate for adding a line to the sheet. If the range is part of a carefully formatted report, check whether the new row inherits the expected formatting. Excel commonly carries formatting from nearby rows, but the result can depend on the sheet and insertion point.

What happens to data, formulas, and formatting

Inserting a worksheet row shifts existing cells below the insertion point down rather than overwriting them. Excel generally adjusts cell references in formulas to reflect the changed positions. For instance, a formula that refers to a cell in a shifted row will ordinarily continue referring to the corresponding data after the row is inserted. The details can depend on the formula, the referenced range, and whether the data is in a table, so verify important calculations after structural changes.

Formatting and other sheet features may also be affected. Excel may copy formatting from the row above or below, and it adjusts many features that refer to cell ranges. However, do not assume every workbook element will behave exactly as intended: merged cells, conditional formatting, named ranges, charts, data validation, and external links can make a sheet more complex. After adding rows to a workbook used for reporting or analysis, inspect relevant totals and outputs.

Inserting a row is not the same as clearing one. It preserves the existing data by moving it down and creates a new space above. If you only want to remove the contents of a row while keeping the layout, select the cells and use Delete or Clear Contents instead. If you want to remove the worksheet row itself, select its row number, right-click, and choose Delete.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. Shift+Space selects the current row there, and Ctrl+Shift++ is the standard insert shortcut. Keyboard layouts differ: on a US keyboard, plus is usually produced with Shift and the equals key; a numeric keypad may have a separate plus key. If the combination does not register, select the row and use the ribbon or right-click menu instead.

In Excel for Mac, Shift+Space selects the row. The insert shortcut can depend on the keyboard and macOS or Excel configuration; the commonly used combination is Control+Shift++. If that key sequence is awkward or does not work on your keyboard, select the row and use the menu or ribbon command to insert it. Do not substitute Command for Control without checking the shortcut: Mac Excel does not use the same modifier for every Windows command.

Excel for the web runs in a browser, where browser shortcuts can compete with spreadsheet shortcuts and keyboard behavior may differ. You can select the row by clicking its number, then use the ribbon’s Home > Insert command and choose the sheet-row option. If a shortcut works in the desktop app but not in the browser, use the ribbon or the row-header context menu rather than assuming the workbook itself is at fault.

Common shortcut problems and fixes

The shortcut opens an Insert dialog. You may have selected cells rather than a complete row. Press Esc, select a cell in the target row, press Shift+Space, and try again.
The plus key combination does nothing. Try Ctrl+Shift+=, check whether your keyboard has a separate plus key, or use Home > Insert > Insert Sheet Rows.
The row appears in the wrong place. Excel inserts above the selected row. Undo with Ctrl+Z if appropriate, select the row below the intended position, and insert again.
Only part of the data shifts. A cell range, rather than a whole row, may have been selected. Select the row number or use Shift+Space before inserting.
The command is unavailable. The worksheet may be protected, or the workbook may restrict structural changes. Check the Review tab for sheet protection; you may need permission or the appropriate password to make the change.

Filters and hidden rows can also make the sheet harder to read. The row numbers show the worksheet’s underlying row positions, but filtered-out records may not be visible. Before inserting into a filtered list, confirm the target by checking the row number and nearby values. If the records are in an Excel table, adding a table row through its context menu is often less confusing than inserting a general sheet row.

Undoing an insertion and working safely

If the new row was inserted in the wrong place, press Ctrl+Z on Windows immediately to undo it. On Mac, use Command+Z. Undo is most dependable before you make other edits; later actions may need to be undone first. If you have already saved or continued working, you can still correct the layout manually, but check the affected data and formulas rather than deleting a row automatically.

For important workbooks, save before making a series of structural edits, especially when they affect formulas, tables, or shared reports. Inserting a row is normally reversible, but subsequent edits and collaboration can make it harder to restore the exact prior state. If the workbook is shared, coordinate changes so another person is not entering data in the area being rearranged.

When several records need space, insert the required number of rows in one operation by selecting that many adjacent row headers. This is usually clearer than repeating the shortcut many times, and it helps preserve the intended spacing. Review the first and last affected rows afterward to confirm that no data was displaced unexpectedly.

Frequently Asked Questions

What is the shortcut to insert an entire row in Excel?
On Windows, press Shift+Space to select the current row, then Ctrl+Shift++ to insert a row above it. If the row is already selected by its number, use the insert shortcut directly.

Does Excel insert the row above or below?
It inserts above the selected row. To place a new row between rows 10 and 11, select row 11 and insert.

How do I insert multiple rows at once?
Select the same number of adjacent row headers as the number of rows you want, then use the insert shortcut or right-click and choose Insert. Excel adds that many rows above the first selected row.

How do I insert a row without using the keyboard?
Select the row by clicking its number, then right-click the row header and choose Insert. In the ribbon, use Home > Insert > Insert Sheet Rows.

Why does Excel ask whether to shift cells?
You likely selected a group of cells rather than an entire worksheet row. Select the row number or press Shift+Space first if all columns should move together.

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.