Insert Row in Excel: Keyboard Shortcut and Options

In Excel for Microsoft 365 on Windows, select the row where the new one should go, then press Ctrl+Shift+= (the plus key on most keyboards) to insert a row above it. If you have selected only a cell, the same shortcut opens the Insert dialog; choose Entire row and select OK.

The Windows shortcut and what it does

The shortcut is often written as Ctrl++ or Ctrl+Shift+Plus. On a standard keyboard, making a plus sign usually requires holding Shift while pressing the equals key, so the practical key combination is Ctrl, Shift, and = together. The exact keycap may show both = and +. On a numeric keypad with a dedicated plus key, Ctrl and that plus key may also work.

The result depends on what is selected before you press the shortcut:

A whole worksheet row is selected: Excel inserts a blank worksheet row above the selected row.
One cell is selected: Excel opens the Insert dialog, where you can choose to shift cells down, shift cells right, insert an entire row, or insert an entire column.
A range of cells is selected: Excel may show the Insert dialog so you can specify how the selected cells should be handled.

This distinction explains why the shortcut seems to work differently for different people. To insert a full row without the dialog, select the row itself first. The new row appears above the selection, not below it. For example, selecting row 8 and using the shortcut adds a blank row 8; the old row 8 and the rows beneath it move down.

Select a row before inserting

You can select a row by clicking its numbered row header at the left edge of the worksheet. To use the keyboard, click a cell in the target row and press Shift+Space. Then press Ctrl+Shift+=. This is useful when you want to keep your hands on the keyboard or are working in a large sheet where accurately clicking a narrow row header is awkward.

For example, if a list starts in row 2 and you need a blank line before the current row 12, click any cell in row 12, press Shift+Space, and then use the insert shortcut. Excel creates a new row 12. You can type the new record there, while the old contents from row 12 move to row 13.

To select several adjacent rows, drag across their row headers or select a cell in the first row and extend the selection with Shift+Space and the arrow keys. The number of rows selected determines how many rows Excel inserts. Selecting rows 8 through 10 and inserting creates three blank rows above row 8. If you only need one new row, check that one row header—not a block of several—is selected.

Insert rows with the ribbon or a context menu

If you do not want to use a shortcut, select the destination row and choose Home > Insert > Insert Sheet Rows. Excel adds a worksheet row above the selected row. This ribbon command is a useful alternative when a keyboard layout makes the plus shortcut unclear or when you are using a device without a full keyboard.

You can also right-click the selected row header and choose Insert. Right-clicking a cell instead of a row header generally brings up an Insert dialog, because Excel needs to know whether you mean cells, a row, or a column. Selecting the row header first removes that ambiguity.

These options change the worksheet structure, rather than merely adding an empty cell. That matters when a sheet contains several columns of related data: inserting a whole row keeps the existing records on the same rows across the worksheet. Inserting cells and shifting only part of a range can misalign values that are meant to stay together.

Insert more than one row at a time

You do not have to repeat the shortcut for every blank row. Select as many existing worksheet rows as you want to add, then use the insert shortcut once. Excel inserts the same number of rows immediately above the first selected row. For example, select rows 20, 21, and 22 to add three blank rows above the original row 20.

The selection can include rows that already contain data: inserting moves those rows down; it does not replace their contents. Still, take care when selecting a large block. If you accidentally select ten rows, Excel will insert ten, and the surrounding data will shift by ten rows. You can immediately undo an accidental insertion with Ctrl+Z, provided you have not taken an action that clears the undo history.

When adding rows at the bottom of a dataset, select the first existing row below the intended new space if one is available. If the data reaches the bottom of the worksheet, Excel cannot insert another worksheet row beyond its limit. In that unusual case, you must remove or move rows elsewhere before making room.

Rows inside an Excel table

An Excel table is a formatted, structured data range, often created with Insert > Table or Ctrl+T. Inserting a worksheet row near a table can affect the surrounding sheet, but when you are adding a record to the table, it is often clearer to insert a table row. Right-click a cell in the table and use the table-row insertion command, such as Insert > Table Rows Above, when that option is available in the context menu.

You can also add a record by typing in the row directly below a table; Excel commonly expands the table to include adjacent entered data. Another straightforward approach is to click the last cell in the table and press Tab, which moves to a new row at the end. These methods add table records, while inserting an entire worksheet row changes the grid beyond the table as well.

Choose based on what you intend to change. If the new item belongs in the middle of a table, add a table row at that position. If you need an empty line across the entire worksheet—for example, to separate sections—insert a sheet row. Table formulas, calculated columns, filters, and formatting are managed as part of the table, so adding a table row can preserve its structured behavior more predictably than placing unrelated blank cells into its range.

What happens to formulas and formatting?

When you insert a worksheet row, Excel moves existing cells below the insertion point down. References in many formulas adjust to account for the inserted cells. For instance, a formula referring to a cell that moves from B12 to B13 will generally be updated to keep pointing to that moved data. The precise effect depends on the formula and where the insertion occurs, so inspect important calculations after making structural changes.

Formatting for a new row is usually copied or inferred from nearby rows. Excel may offer an Insert Options control after an insertion so you can choose how the new row is formatted, such as matching the formatting above or below, or clearing formatting. The available choices can depend on the worksheet content. A blank-looking row may still contain borders, number formats, validation rules, or conditional formatting, so visual appearance alone does not tell you everything about its setup.

In a table, a new row usually inherits the table’s style and may carry calculated-column formulas into the new record. If a formula or format does not appear as expected, compare the new row with neighboring rows and check whether the data is inside the table boundary. Inserting a row outside the table is not the same as adding a record to the table.

Excel on Mac and in a web browser

In Excel for Mac, selecting a whole row and pressing Control+Shift+Plus is the corresponding insert-row shortcut on supported keyboard layouts. The plus sign may require a different physical key combination depending on the keyboard, language, and Mac configuration. If the shortcut is inconvenient, select the row and use the ribbon’s Home > Insert command, or use the row-header context menu. Menu commands are the more dependable fallback when shortcut behavior differs.

Excel for the web also provides row insertion through the ribbon and row-header context menu. Keyboard shortcuts in a browser can be affected by the browser, operating system, or keyboard settings, so if Ctrl+Shift+= does not produce the expected result, select the row header and use the ribbon command. Confirm that you are selecting a worksheet row rather than a cell if you want a complete row inserted.

These instructions concern Excel, not Google Sheets or another spreadsheet program. Similar-looking shortcuts in other applications may have different effects. If a workbook is open in a browser-based spreadsheet, check that application’s own menu and shortcut guidance rather than assuming Excel’s behavior applies.

Common problems and quick checks

If the shortcut opens a dialog instead of immediately adding a row, the most likely reason is that a cell—not its entire row—is selected. Press Esc to close the dialog, click the row number or use Shift+Space, and try again. If the shortcut does nothing, check whether the keyboard layout requires Shift to type +, whether a dialog or cell-editing cursor is active, and whether a browser or another application has intercepted the keystroke.

The new row appeared in the wrong place: Excel inserts above the selected row. Undo, select the row below the intended position, and insert again.
Only part of the data shifted: You may have selected cells rather than the row header. Undo and insert a whole worksheet row to keep records aligned across columns.
More rows appeared than expected: Check how many row headers were selected. Undo and select only the required number.
The row looks different: Use the Insert Options control if it appears, or copy the appropriate formatting from a neighboring row.
You cannot add a row: Check for worksheet protection, which can restrict structural changes, or for a selection that reaches the worksheet’s final row.

Before making a large structural change in an important workbook, consider saving a copy. This is especially sensible in shared or complex workbooks, where inserted rows can affect formulas, charts, named ranges, and other linked content. A quick check of totals and key references after insertion can catch an unintended shift before it spreads into later work.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
On Windows, select the row and press Ctrl+Shift+=, which is commonly described as Ctrl+Shift+Plus. The inserted row appears above the selected row.

How do I insert a row without opening the Insert dialog?
Select the whole worksheet row first by clicking its row number or pressing Shift+Space from a cell in that row. Then use Ctrl+Shift+= on Windows.

Can I insert multiple rows with one shortcut?
Yes. Select the same number of existing row headers as the number of blank rows you need, then press the insert shortcut once. Excel inserts that many rows above the first selected row.

Does Ctrl+Shift+= insert a row below the selected row?
No. When a whole row is selected, Excel inserts above it. To place a blank row between two existing rows, select the lower row and insert.

What is the Excel row-insert shortcut on a Mac?
Control+Shift+Plus is the corresponding shortcut when supported by the keyboard layout. If it is awkward or does not work, select the row and use the Home > Insert command or the row-header context menu.

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.