Excel Insert Row Shortcut: Steps for Windows and Mac

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the row where you want a new row, then press Ctrl+Shift+= (the plus sign on a US keyboard) to insert a blank row above it. To select a row from a cell, press Shift+Space first; on a Mac, the equivalent insert shortcut is generally Control+Shift+=.

The quickest way to insert a worksheet row

Excel inserts a row above the selected row, so first decide where the new blank space should appear. If you want a row between the current rows 8 and 9, select row 9, then use the shortcut. Excel inserts a new row 9 and moves the former row 9, along with the rows below it, down by one.

  1. Click any cell in the row that should move down, or click its row number at the left edge of the sheet.
  2. If you clicked a cell, press Shift+Space to select its entire worksheet row.
  3. Press Ctrl+Shift+=. On many keyboards, this means holding Ctrl and Shift while pressing the equals key, which produces the plus sign.

You can also use the plus key on a numeric keypad with Ctrl if your keyboard has one. The exact keystroke can vary with keyboard layout, so the reliable principle is to select the whole row and invoke Excel’s Insert command. The shortcut creates a blank row; it does not copy the selected row’s values into the new one.

What happens if you select only a cell?

If you select a single cell rather than the row header and press the insert shortcut, Excel may show the Insert dialog instead of adding a whole worksheet row immediately. The dialog lets you choose whether to shift cells right, shift cells down, insert an entire row, or insert an entire column. Choose Entire row when that option appears.

This distinction matters because inserting cells can change the shape of a data range in ways you did not intend. For instance, inserting only one cell in the middle of a table-like range may shift neighboring cells without moving the rest of each record. Selecting the row number first makes your intention clear: insert a full worksheet row and move everything below it down.

In a normal range, clicking the row number is a straightforward way to select a worksheet row. If your active cell is inside an Excel Table, selection and insertion can behave in a table-aware way instead. For a new record within a table, use the table’s row-insertion option rather than assuming that a worksheet-row command and a table-row command are identical.

Insert several rows at once

To add multiple blank rows in one operation, select the same number of existing rows as the number you want to insert, then use the shortcut. For example, to add three rows above row 10, select rows 10 through 12 and press Ctrl+Shift+=. Excel inserts three rows above the selection. It does not matter that the selected rows contain data: their contents move down intact.

To select a range of whole rows, click the first row number and drag through the last, or select a row and extend the selection with Shift+Up Arrow or Shift+Down Arrow. Check the highlighted row numbers before inserting. Selecting five rows by mistake will add five blank rows, which can make later sorting, formulas, and print layouts confusing.

There is no need to repeat the shortcut separately for each new row if you know the desired count. Selecting the number of rows you want inserted is typically faster and reduces the chance of placing rows at slightly different locations.

Ribbon, mouse, and right-click alternatives

If you cannot remember the keystroke, Excel provides the same general worksheet-row operation through the ribbon. Select a row, then choose Home > Insert > Insert Sheet Rows. The wording may be shortened or displayed differently in some ribbon layouts, but the Insert menu on the Home tab contains the sheet-row command.

You can also right-click a selected row number and choose Insert. This is useful when you want to work with the row headers directly or are using a mouse without a number pad. When a cell rather than a row is selected, right-clicking and choosing Insert may open a dialog that asks how to shift cells, so select the row header first if you want a complete row.

On English-language Windows Excel, the ribbon KeyTips provide another keyboard route: press Alt, then H, I, and R to reach the Insert Sheet Rows command. KeyTips are the letters or labels Excel displays over ribbon controls after Alt is pressed. They can differ with language, version, or ribbon configuration, so follow the labels shown on your screen if that sequence does not match.

Windows, Mac, and Excel for the web

The main instructions above are for Excel on Windows. On Excel for Mac, select the row and use Control+Shift+= on a typical keyboard. This shortcut uses Control rather than Command; many Excel actions use Command on Mac, but not every Windows shortcut changes to Command. Keyboard layouts and compact keyboards can affect how you enter the plus sign, so the menu or right-click method is a practical fallback.

Excel for the web has a similar ribbon command: select the row, then use Home > Insert and choose the option to insert sheet rows. Keyboard shortcuts in the browser can depend on the browser, operating system, and whether Excel has focus. In particular, a plus-key combination may be intercepted by the browser as a zoom command. If the shortcut changes page zoom or does not insert a row, use the ribbon command rather than repeatedly pressing keys.

In all versions, verify that the selection is in the worksheet and that the intended row is highlighted before inserting. Excel for Windows, Mac, and the web can differ in interface details, but inserting above a selected row is the central behavior.

Rows in Excel Tables and filtered lists

An Excel Table is a structured range with features such as filter buttons and automatic expansion. A worksheet row and a table row are related but not interchangeable concepts. If your goal is to add a record to a table, click inside the table and use its row insertion choices, such as right-clicking a table row and choosing Insert > Table Rows Above when that option is available. The table can then extend its formatting and calculated-column behavior to the new record.

Adding an entire worksheet row through a row header can also affect cells outside the table on that same sheet. That may be what you want when inserting a line across a complete worksheet, but it can be disruptive if you only meant to add one table record. For a filtered table, inserting a table row is usually clearer than choosing a visible record and assuming that the worksheet shortcut will add a row in the filtered display order.

When a range is filtered, remember that hidden rows remain part of the worksheet. A full worksheet-row insertion shifts rows below the insertion point, including rows that may not currently be visible. Review the surrounding data after the change, especially if formulas or other ranges sit beside the filtered list.

Common problems and how to fix them

  • The shortcut opens an Insert dialog: You likely selected a cell rather than a complete row. Select the row number, or choose Entire row in the dialog.
  • The plus sign is hard to type: On a standard US keyboard, plus is Shift plus the equals key, so the combination is Ctrl+Shift+=. A numeric keypad plus key may work with Ctrl.
  • The browser zooms in: This can happen in Excel for the web when the browser captures the plus shortcut. Use the Home tab’s Insert command instead.
  • The wrong number of rows appears: Excel inserts as many rows as you selected. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the intended count and try again.
  • Excel will not insert a row: The sheet may be protected, or the insertion could push data beyond the worksheet’s last row. Check the Review tab for sheet protection and inspect the bottom of the sheet for occupied cells.

After inserting, check formulas, merged cells, and formatting near the change. Excel generally adjusts references when rows are inserted, but a workbook may also contain fixed ranges, external links, charts, or macros that rely on a particular layout. If the sheet is important, save a copy before making a large structural change.

Inserting a row is different from clearing one

Inserting a row creates new space and moves existing content downward. It does not erase or replace the row you selected. By contrast, pressing Delete or choosing a clear command removes cell contents but leaves the worksheet row in place. Deleting a row removes the row itself and shifts rows below upward. These operations have different effects on references and layout, so confirm which one you need before using a shortcut.

A practical example: if row 5 contains a heading and row 6 contains the first record, selecting row 6 and inserting adds a blank line between the heading and that record. If you instead select row 6 and delete the row, the first record is removed and later records move up. For a simple blank line, insertion is the right operation.

Frequently Asked Questions

What is the shortcut to insert a row in Excel?
On Windows, select the row and press Ctrl+Shift+=, commonly described as Ctrl+Shift+Plus. On a Mac, the usual equivalent is Control+Shift+=. If only a cell is selected, Excel may ask how you want to insert cells.

How do I insert a row above in Excel?
Select the row that should move down, then run the insert command. Excel places the new blank row above the selected row, not below it.

How can I insert multiple rows at once?
Select the same number of whole rows as the number you want to add, then use the insert shortcut or the ribbon command. Excel inserts that many rows above the selection.

Can I insert a row without a keyboard shortcut?
Yes. Select a row number, right-click it, and choose Insert, or use Home > Insert > Insert Sheet Rows. These methods are also helpful if your keyboard layout makes the plus combination awkward.

Why does Excel show an Insert dialog instead of adding a row?
That usually means a cell, not an entire row, was selected. Choose Entire row in the dialog, or cancel, select the row header, and repeat the shortcut.

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.