Excel Keyboard Shortcut to Add a Row (Windows & Mac)

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+= (the plus sign, usually typed as Ctrl+Shift+=). Excel inserts a blank row above the selected row. To select a row first, click its number at the left of the worksheet or press Shift+Space while a cell in that row is active.

The quickest way to insert a row

The shortcut works most predictably when you select an entire worksheet row before using it. For example, to add a blank row between rows 8 and 9, select row 9 and press Ctrl+Shift+=. The new row appears above row 9, and the existing row 9 moves down. Excel does not insert the new row below the selected row.

  1. Click a cell in the row where you want the new row to appear above.
  2. Press Shift+Space to select the whole row. You can instead click the row number in the row headings.
  3. Press Ctrl+Shift+=. On a keyboard where the plus sign shares the equals key, hold Ctrl and Shift while pressing =.

If you select only a cell rather than the whole row, Excel may show the Insert dialog instead of immediately adding a worksheet row. That dialog lets you choose whether to shift cells down or insert an entire row. Choose Entire row when you want a new row across the sheet. This distinction matters because inserting cells is not always the same as inserting a row: shifting only a small selection can leave neighboring columns misaligned.

What the shortcut does—and where the row goes

Inserting a worksheet row changes the grid structure, not just the contents of a few cells. Excel moves the selected row and all rows below it down by one position, while rows above it stay in place. Formulas that refer to affected cells are generally adjusted as Excel moves the cells, and formatting is often inherited from an adjacent row. Check important formulas, references, and formatting after a structural change, especially in a complex workbook.

The insertion point determines placement. Select row 12 and insert: the blank row becomes row 12, and the old row 12 becomes row 13. If your goal is to put a new row after the last data row, select the worksheet row immediately below that data and insert there. Alternatively, when working at the bottom of an Excel table, pressing Tab in its last cell can create a new table row without using the worksheet-row shortcut.

There is no need to select a row by dragging across its cells. Clicking the row heading is a clear visual method, while Shift+Space is convenient when your hands are already on the keyboard. If a multi-cell range is selected, inspect the selection before inserting: the number and shape of selected cells can affect whether Excel inserts rows, shifts cells, or opens a dialog.

Other ways to add a worksheet row

The keyboard shortcut is useful for repeated edits, but the ribbon and context menu provide visible alternatives. These can be easier to remember or use when a shortcut is unavailable.

  • Ribbon: Select a row, then choose Home > Insert > Insert Sheet Rows. The Insert control is in the Cells group.
  • Context menu: Right-click a row heading and choose Insert. Selecting the row heading first makes the intent clear.
  • Keyboard access keys: In desktop Excel for Windows, press Alt, then H, I, R to invoke Insert Sheet Rows through the ribbon key tips. Press the keys in sequence, rather than holding them all down together. Key-tip behavior can vary with the active interface or localization, so the ribbon command is a dependable fallback.

These methods insert a row above the selected row, just like the main shortcut. The context menu is particularly helpful when you want to confirm you are acting on a whole row rather than shifting a small group of cells. The ribbon is also useful for people learning Excel because it exposes the command name instead of requiring them to remember a key combination.

Adding several rows at once

To insert several blank rows in one operation, select the same number of existing worksheet rows as the number you want to add, then use Ctrl+Shift+=. For example, select rows 6 through 8 and insert; Excel adds three rows above row 6. The selected rows are used to determine the count, so selecting only one row and repeating the shortcut three times is not necessary.

You can select a continuous block by dragging over its row headings, or click the first row heading and Shift-click the last. For nonadjacent row selections, insertion can be less intuitive because the selected areas are separated. When you need a precise contiguous block, select a continuous range of row headings and insert once. Confirm the result before entering data, particularly when the worksheet contains totals, formulas, or print layouts that depend on row positions.

For a concrete example, suppose a list occupies rows 2 through 20 and you need space for three new entries before the current row 10. Select row headings 10, 11, and 12, then press Ctrl+Shift+=. Excel creates three blank rows starting at row 10; the existing entries in rows 10 and below move down three positions. Type the new records into the inserted rows and check any manually maintained numbering or references.

Worksheet rows versus Excel table rows

An Excel table is a structured, formatted data range with features such as filter buttons and automatically expanding formulas. It sits on the worksheet grid, but adding a table record and inserting an entire worksheet row are different operations. If you want to add a record to the end of a table, click its last cell and press Tab. Excel creates a new table row and extends the table. You can also begin typing in the row directly below the table in many common layouts, and Excel may expand the table automatically.

To add a blank row within a table, right-click a cell in the table row above the intended position and use the table insertion command, or use the worksheet row insertion method when you intend to shift the entire sheet. The distinction matters if other information sits beside the table. Inserting a worksheet row affects every column across the sheet; adding a table row changes the table area and may not be the right choice when you need a full-width break in a worksheet layout.

Table formulas and formatting can fill into a newly added table row automatically, depending on the table’s settings and the surrounding data. That behavior is convenient for records but should not be mistaken for a guarantee that every unrelated formula or format elsewhere in the workbook will update as intended.

Choosing the right method for the job

Use the keyboard shortcut when you need a whole worksheet row and want to keep your hands on the keyboard. Use the row-heading context menu when you want a visual confirmation, or use the ribbon if you prefer to locate commands by name. For a new record at the end of a table, Tab is often the more direct tool because it expands the table rather than adding an unrelated blank row across the worksheet.

Before inserting, ask what should move. If every value below a point needs to move down together, insert a worksheet row. If only a block of cells should move, select that block and use an insertion option carefully; this can make adjacent columns no longer describe the same record. If you are adding space inside a formatted report, check merged headings, subtotals, and print areas after the change. The most appropriate method depends on the shape of the data, not simply on which shortcut is fastest.

Common problems and how to fix them

  • The Insert dialog appears: You probably selected a cell or range, not a whole row. Choose Entire row in the dialog, or cancel, select the row heading, and use the shortcut again.
  • The shortcut seems to do nothing: Check that Excel is active and the worksheet is not protected against row insertion. If the sheet is protected, the person who protected it may need to allow row insertion or unprotect it. A workbook can also have restrictions imposed by permissions.
  • A different key is being entered: The plus sign is commonly on the same key as equals. Press Ctrl and Shift together with that key. On some keyboards, a separate numeric keypad plus key may work as Ctrl+plus without Shift.
  • The new row is in the wrong place: Excel inserts above the selected row. Undo immediately with Ctrl+Z if appropriate, then select the row below the desired position and insert again.
  • The layout looks different afterward: Excel may copy formatting from an adjacent row, and formulas may adjust as cells move. Review borders, number formats, conditional formatting, formulas, and totals rather than assuming the new row is completely neutral.

If Ctrl+Z is available, it can undo an ordinary row insertion. Avoid making several unrelated edits before undoing if you are unsure which action will be reversed; Excel’s undo history follows the sequence of recent actions. For a workbook with important data, saving a copy before substantial restructuring is a sensible precaution.

Using the shortcut on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, select the row and use Control+Shift+= to insert a worksheet row above it. The plus sign is typically entered with Shift and the equals key, though the exact key feel depends on the keyboard layout. Shift+Space can select the current row on Mac as well. If the shortcut is intercepted by macOS or does not behave as expected, use the menu or context menu to insert the row.

Excel for the web runs in a browser, where browser and operating-system shortcuts can affect key combinations. Selecting a row heading and choosing the Insert command from the ribbon or the row’s context menu is a reliable alternative when the desktop shortcut does not work in the browser. The same placement rule applies: the row is inserted above the selected row. The web interface can change over time, so rely on the visible Insert command if keyboard behavior differs on your device.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
On Windows, select a row and press Ctrl+Shift+=. This is the plus-sign shortcut, often described as Ctrl+Shift+Plus. On Mac, use Control+Shift+=, subject to keyboard layout and system shortcut behavior.

How do I insert a row above in Excel?
Select the row that should move down, then use the insert shortcut or Home > Insert > Insert Sheet Rows. Excel places the new blank row above the selected row.

Can I insert multiple rows with one shortcut?
Yes. Select the number of existing rows you want to add, then press the insert shortcut once. Selecting three row headings inserts three rows above the first selected row.

Why does Excel open an Insert dialog instead of adding a row?
That usually happens when a cell or cell range is selected rather than an entire row. Select the row heading first, or choose Entire row in the dialog if that is the action you want.

How do I add a row to an Excel table?
To extend a table at its end, select its last cell and press Tab. To add a row within the table, use an insertion command appropriate to the table position; use worksheet-row insertion when you need the whole sheet below that point to move down.

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.