Excel New Row Shortcut: Insert Rows Above or Below

In Excel for Microsoft 365 on Windows, select the row where you want the new one, then press Ctrl+Shift+= (the plus-sign shortcut) to insert a row above it. To insert below a particular row, select the row immediately beneath it first; Excel inserts the new row above the selection.

The shortcut at a glance

The shortcut works according to what is selected. If you select a whole worksheet row, Excel inserts a complete blank row above it. If you select only a cell, Excel opens the Insert dialog, where you can choose what to insert. That distinction is useful: selecting the row first makes the action predictable and avoids an extra dialog.

Insert one full row: select its row header, then press Ctrl+Shift+=.
Select a row from a cell: click a cell in it and press Shift+Space; then use the insert shortcut.
Insert above: select the row that should move down.
Insert below: select the row immediately below the desired position.

On a standard US keyboard, the plus sign shares the equals key, so you usually press Ctrl+Shift+=. Microsoft documentation often describes this as Ctrl+plus. Keyboard layouts differ, so use the key that produces a plus sign if your layout puts it elsewhere. On some keyboards, a dedicated plus key may work without the Shift key.

Insert one row above or below

Suppose a worksheet has headings in row 1 and a list of orders beginning in row 2. To add a blank row before the order currently in row 5, select row 5 and use the shortcut. The former row 5 moves to row 6, and the new row occupies row 5. Existing rows below shift down; Excel does not overwrite their contents.

You can select the row in either of two ways. Click its numbered header at the left edge of the worksheet, or click a cell in the row and press Shift+Space. When the entire row is highlighted, press Ctrl+Shift+=. If you select a cell range rather than a whole row, Excel may offer choices in the Insert dialog instead, because it needs to know whether you mean cells, a row, or a column.

To add a row at the end of a list, select the worksheet row immediately after the current last row and insert. For instance, if the last record is in row 25, select row 26. Excel creates a blank row there without moving the existing records. In a formatted Excel table, however, adding a table record and inserting a worksheet row are related but not identical operations; see the table section below.

Insert several rows at once

To add multiple consecutive rows in one action, select the same number of existing row headers as the number of rows you want to add, then use the shortcut. Excel inserts that many blank rows above the first selected row. For example, select row headers 8, 9, and 10, then press Ctrl+Shift+=. Three rows are inserted above the former row 8, and the selected records move down.

To select a run of rows, click the first row number and drag through the last, or click the first row number, hold Shift, and click the last one. If you prefer the keyboard, select a cell in the first row, press Shift+Space to select that row, then extend the selection with the appropriate navigation keys. Check the highlighted row numbers before inserting, especially in a large sheet: the number of selected rows determines the number Excel adds.

This method is often quicker and less error-prone than repeating the shortcut several times. Repeating it can still be appropriate for separate insertion points, but each insertion shifts worksheet positions and may change which row you need to select next.

What Excel changes when it inserts a row

Inserting a worksheet row shifts existing cells below the insertion point downward. Formulas that refer to affected cells are generally adjusted by Excel so their references continue to point to the intended cells. For example, inserting a row within a referenced range can expand that range. Still, inspect important formulas after structural edits, particularly formulas with fixed references, references to other sheets, or complex ranges.

A new row is blank in the sense that it has no newly entered record values, but its appearance may not be completely unformatted. Excel can carry formatting from a nearby row, and an Insert Options control may appear after insertion so you can choose how formatting is applied. A blank inserted row also does not necessarily acquire every formula in an ordinary range automatically. If you need formulas or formatting, verify the result rather than assuming every column has been populated.

Excel tables behave differently in a useful way. When a row is inserted within a table, the table expands and its structure, such as calculated-column formulas, can be maintained. A calculated column is a table column in which Excel applies the same formula pattern to records. This behavior is one reason to use a real table for expanding lists, but it does not mean every inserted worksheet row outside the table becomes a table record.

Other ways to add a worksheet row

The keyboard shortcut is not the only route, and the alternatives are helpful when you do not remember the key combination or need to confirm what Excel will insert.

Ribbon: select a row, then choose Home > Insert > Insert Sheet Rows.
Row-header menu: right-click the numbered row header and choose Insert.
Cell selection: select a cell and use the shortcut to open the Insert dialog, then choose Entire row if that is the intended action.

For a whole worksheet row, the row-header menu is especially clear because the selection itself identifies the row to be inserted above. The ribbon command is useful for keyboard-and-mouse workflows, and it also helps distinguish inserting sheet rows from inserting cells or table rows. Menu wording or placement can vary slightly across Excel interfaces, but the Windows desktop ribbon command is under Home and Insert.

Rows in an Excel table

An Excel table is a structured range with its own headers and table features. If you want a new record inside a table, click a cell in the table row that should move down and use the table-row insertion command from the context menu or the Insert menu. Excel adds a table row above the selected table row. Selecting the worksheet row header and inserting a sheet row also shifts the table, but the table-specific command makes your intention explicit.

For a new record at the bottom of a table, you can often type in the first row immediately below it; Excel can expand the table to include the entry. Another convenient option is to select the last cell in the table and press Tab, which creates a new table row. This is different from inserting a worksheet row at an arbitrary location: it adds a record at the table’s end and is designed for ongoing data entry.

If the new table row seems to copy formulas or formatting automatically, that is table behavior, not a guarantee about ordinary worksheet ranges. Conversely, if you only need a blank worksheet row between unrelated sections, use the regular row insertion shortcut rather than relying on table expansion.

Mac and Excel for the web

In Excel for Mac, the corresponding insert shortcut uses Control+Shift+= for the plus sign on common keyboard layouts. The key distinction is that the Mac combination uses Control, not Command, for this insertion shortcut. Select a whole row first if you want a complete worksheet row; otherwise, Excel may show the Insert dialog. Mac keyboard layouts can differ, so the physical key sequence may vary.

Excel for the web also provides row insertion through its ribbon and row-header context menu. Keyboard shortcuts can depend on the browser and on whether a browser command conflicts with Excel’s shortcut handling. If the key combination does not produce the expected result, select the row number and use the visible Insert command instead. That route also makes it easier to confirm whether you are inserting a sheet row or adding a row to a table.

Common shortcut problems

The Insert dialog appears: you probably selected a cell rather than the entire row. Choose Entire row, or cancel, select the row header, and try again.
Nothing happens: check that Excel has focus, and confirm that you used the plus-sign combination for your keyboard layout. On a US keyboard, plus is usually Shift+=.
The row appears in the wrong place: Excel inserts above the selected row. Select the row below your intended position if you meant to insert below an existing row.
Only part of the data moves: check whether the list is a continuous range or a table, and whether entire rows or just cells were selected. A partial selection can lead to a different insertion choice.
Formatting or formulas look unexpected: inspect nearby rows and any Insert Options control. Excel’s behavior differs between a normal range and a table.

Before inserting rows into a carefully arranged worksheet, consider whether formulas, charts, print areas, or references in other sheets depend on the affected area. Insertion is normally straightforward and does not erase the rows below, but complex workbooks can contain layouts that rely on specific positions. Undo with Ctrl+Z immediately if the result is not what you intended; avoid making further edits first, since they become additional steps in the undo history.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
In Excel for Windows, select the whole row and press Ctrl+Shift+=, which types the plus-sign shortcut on a standard US keyboard. The row is inserted above the selected row.

How do I insert a row below the current row?
Select the row immediately below the position where you want the new row, then use the insert shortcut. Excel inserts above the selection, so selecting the current row would put the new row above it instead.

Can I insert multiple rows with one shortcut?
Yes. Select as many whole row headers as the number of rows you want, then use the shortcut once. Excel inserts the same number of rows above the first selected row.

Why does Excel show an Insert dialog instead of adding a row?
The selection is likely a cell or a group of cells rather than a complete worksheet row. Select the row number at the left, or choose Entire row in the dialog.

Does the same shortcut work in Excel for Mac?
The common Mac combination is Control+Shift+=, with Control rather than Command. If your keyboard layout or Excel interface handles it differently, select the row and use the Insert command from the ribbon or 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.