Excel Insert Row Above Shortcut: Keys and Other Options

In Excel for Microsoft 365 on Windows, select the row where the new row should go, then press Ctrl+Shift++ (Ctrl plus the plus key) to insert a blank row above it. If you select a cell instead of the whole row, the shortcut opens the Insert dialog; choose Entire row and confirm.

Shortcut at a glance

The shortcut inserts worksheet rows at the current selection. The important detail is whether you selected an entire row or only one or more cells:

Whole row selected: Press Ctrl+Shift++. Excel inserts the same number of rows above the selected row or rows.
One or more cells selected: Press Ctrl+Shift++ to open the Insert dialog, then select Entire row and click OK. Depending on the selection and Excel settings, the dialog may offer choices for shifting cells instead.
Using a numeric keypad: Press Ctrl and the keypad’s plus key. On a standard US keyboard, the plus sign above the equals key is typed with Shift, so the shortcut is often entered as Ctrl+Shift+=.

Excel’s notation can look slightly different across help pages and keyboard layouts because the plus sign may be a separate keypad key or the shifted version of the equals key. The intended command is Ctrl plus the plus sign, not Ctrl plus the minus key.

Select the row that will sit below the new one

To insert above a particular record, first identify the worksheet row number at its left edge. Click that row number to select the entire row; the row header and all cells across the sheet become highlighted. Then use the shortcut. For example, if a heading is on row 1 and the first data record is on row 2, selecting row 2 and inserting places the new blank row between the heading and the existing record.

This selection-first approach is often the clearest way to avoid inserting only a few cells. If you click a cell such as B8, Excel does not automatically know that you intend to add a complete row. It opens a dialog so you can specify whether to shift cells down, shift cells right, insert an entire row, or insert an entire column. Choose Entire row when you want a new worksheet row across all columns.

You can select multiple adjacent row headers by dragging over them, or select the first row header and Shift-click the last. The shortcut then inserts an equal number of rows above the first selected row. Selecting rows 8 through 10 and using the shortcut, for example, adds three blank rows above row 8. This is useful when you know how many records you need to add at once.

Why the shortcut inserts above

Excel inserts worksheet rows immediately before the selected row, not after it. Inserting above row 8 moves the former row 8 and everything beneath it down, while the new blank row takes the number 8. Row numbers are recalculated after insertion, so a record that used to be on row 8 will then be on row 9.

There is no separate standard keyboard command that means insert below the current row. To add a row below a record, select the row immediately beneath that record and insert above it. If the record is at the very bottom of a data list, select the next worksheet row and insert there. The distinction is based on the selected position, not on the direction of the selection highlight.

Inserting a whole worksheet row affects the full width of the grid, not just the columns that currently contain data. It shifts cells below the insertion point down and can change references, formulas, chart source ranges, and named ranges according to Excel’s normal reference-adjustment rules. It does not merely create extra space in one column.

Use the ribbon or right-click instead

If you cannot remember the shortcut, Excel provides menu alternatives. Select a row header and go to Home > Insert > Insert Sheet Rows. You can also right-click the selected row header and choose Insert. These commands insert a worksheet row above the selected row, just like the keyboard shortcut.

The ribbon route is useful when teaching the operation or when a keyboard layout makes the plus-key shortcut awkward. In desktop Excel for Windows, ribbon KeyTips also provide a keyboard route: press Alt, then H, I, and R in sequence to choose Insert Sheet Rows. KeyTips are letters pressed in sequence, not a combination held down together. If a version, language, or customized ribbon displays different KeyTips, follow the letters shown on screen.

Right-clicking a cell rather than a row header can show an Insert command that opens a dialog or offers cell-specific choices. For a guaranteed full-row insertion, select the row header before opening the context menu. This avoids accidentally shifting cells within only part of the worksheet.

Excel for Mac and Excel for the web

In Excel for Mac, select the row header and use Control+Shift+= to insert a row above. The exact key combination can depend on the keyboard layout, particularly where the plus sign is located. If that shortcut does not work on your Mac, use the row-header context menu or the ribbon’s Insert command instead. On Mac, the Control key—not Command—is used for this insertion shortcut.

Excel for the web has a similar row-header and ribbon workflow, but browser shortcuts can sometimes take precedence or behave differently from desktop Excel. Select the row header and use Home > Insert > Insert Rows if the keyboard combination is intercepted or unavailable. The specific ribbon wording may vary slightly with the web interface. In either edition, inserting above means selecting the row that should move down.

Keyboard layouts also matter on Windows. On some laptops, the plus sign may require an Fn layer, and a separate numeric keypad may make the command easier. If the shortcut is inconvenient, using the row header and Insert command gives the same result without depending on a particular physical key arrangement.

Rows inside an Excel table

An Excel table is a formatted, structured data range with filter buttons and table-specific behavior. If the selected row is inside a table, inserting a worksheet row and adding a table row are related but not always identical actions. To add a record within the table, right-click a cell in the table and choose Insert > Table Rows Above when that option appears. This adds a row to the table and keeps it within the table’s structure.

When you use a worksheet-row command while working near a table, check the result: the new row should be part of the table if that is what you intended. Table formulas may fill down automatically, and structured references can adjust as the table expands. If your goal is only to add a record at the bottom, typing into the row immediately below the table may cause the table to expand automatically, depending on the surrounding content and Excel settings. Verify the table boundary before entering data.

Filters can hide some table or worksheet rows, which can make the visible position confusing. The row header still identifies the actual worksheet row number. If you need a new record among filtered results, consider clearing or adjusting the filter first so you can confirm where the new row will be placed and whether it belongs in the table.

Common problems and how to fix them

If pressing the shortcut opens a dialog instead of inserting immediately, that is usually because you selected cells rather than the entire row. Choose Entire row in the dialog, or cancel it, click the row number, and try again. If nothing happens, check whether the worksheet is protected; a protected sheet may prevent row insertion unless the protection settings allow it.

Other issues can arise from the worksheet’s structure or the selection:

Merged cells: Merged areas that do not align with the inserted range can prevent insertion or produce an error. Review the merged cells near the insertion point and unmerge or rearrange them if appropriate.
Multiple selections: A selection of separate, nonadjacent ranges may not support the insertion as expected. Select one continuous block of row headers and insert that block.
Sheet limits: Excel worksheets have 1,048,576 rows. If inserting would push populated cells beyond the last available row, Excel cannot make room; remove or move content near the bottom first.
Unexpected formatting: A new row may inherit formatting from nearby rows. Use the insert options that appear after insertion, or adjust the new row’s formatting if the inherited style is not suitable.

A frequent misconception is that inserting a row deletes or overwrites the selected row. It does not: the selected row and the rows below it move down to make room. However, the new row may be blank only in the sense that it has no existing values; Excel can carry formatting, formulas, or table behavior into it. Inspect the new row before assuming every cell is empty.

Insert several rows and check the result

For a batch insertion, select as many row headers as the number of rows you need, then run the shortcut once. To add four rows above row 12, select rows 12 through 15 and insert. Excel creates four rows beginning at row 12, moving the former row 12 and subsequent content down. You do not need to repeat the shortcut four times.

After insertion, review nearby formulas and data relationships. Excel normally adjusts direct cell references when rows are inserted within a referenced range, but formulas using text-based addresses, external data, or specialized references can behave differently. If the worksheet feeds a report, chart, or downstream process, check that the new row is included where required. Undo with Ctrl+Z on Windows or Command+Z on Mac if the insertion was accidental and no later action makes undo unsuitable.

Before a large structural edit to an important workbook, saving a copy is a sensible precaution. Inserting one row is ordinarily reversible, but a copy helps protect against follow-up edits, changed formulas, or other actions that are harder to unwind.

Frequently Asked Questions

What is the Excel shortcut to insert a row above?
On Windows, select the row and press Ctrl+Shift++ (Ctrl plus the plus sign). On a US keyboard, this is commonly typed as Ctrl+Shift+=. Selecting the row header first inserts the row directly; selecting only a cell opens the Insert dialog.

How do I insert a row above without using a mouse?
Use the arrow keys to move to a cell in the row, select the entire worksheet row with Shift+Space, then press Ctrl+Shift++ on Windows. If Excel opens the Insert dialog, select Entire row. The exact selection shortcut can vary with keyboard or system settings.

How do I insert a row below in Excel?
Select the row immediately below the desired location and insert above it. Excel inserts before the selected row, so selecting the row beneath your target creates the appearance of inserting below that target.

Can I insert multiple rows at once?
Yes. Select the same number of adjacent row headers as the number of rows you want, then use the insertion shortcut once. Selecting three rows inserts three new rows above the first selected row.

Why does Ctrl+Shift++ open an Insert dialog?
Excel displays the dialog when the selection is a cell or a cell range rather than a whole worksheet row. Choose Entire row, or select the row number at the left of the sheet before using the shortcut.

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.