Excel Shortcut to Insert a Row: Windows and Mac

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the row where the new row should go and press Ctrl+Shift+= (the plus-sign shortcut). To select a worksheet row first, click a cell in it and press Shift+Space; the inserted row appears above the selected row. On a Mac, use Control+Shift+= after selecting the row.

The shortcut and what it does

Excel inserts a new worksheet row above the selected row. For example, if row 8 is selected, the new blank row becomes row 8 and the former row 8 moves down to row 9. The shortcut does not put a row below the selection; to insert below a particular record, select the row currently underneath the intended position.

The plus sign is the important part of the Windows shortcut. On many keyboards, you type it by holding Shift and pressing the equals key, so the combination is written Ctrl+Shift+=. Some keyboards have a separate plus key on the numeric keypad; Ctrl and that plus key may also work. If your keyboard layout or remote desktop makes the key combination awkward, use the ribbon or row-header menu instead.

When a whole worksheet row is selected, Excel inserts a row directly. If only a cell or range of cells is selected, Excel may show the Insert dialog so you can choose whether to shift cells right or down, or insert an entire row or column. Selecting the row first removes that ambiguity.

Fastest method: select the row, then insert

  1. Click any cell in the worksheet row that should move down.
  2. Press Shift+Space to select the entire worksheet row. You can also click its numbered row heading at the left edge of the grid.
  3. Press Ctrl+Shift+= on Windows, or Control+Shift+= on Mac.

For instance, to create space above a heading currently in row 5, click a cell in row 5, select the row, and use the insert shortcut. The heading and its other contents move to row 6, leaving a new row 5 for the additional information. The row number is the safest guide: selecting row 5 inserts above row 5 regardless of which column you clicked.

To add several rows at once, select the same number of existing rows before using the shortcut. To insert three rows above row 5, select rows 5 through 7, then invoke Insert. Excel adds three rows at the top of that selection. You do not need to repeat the shortcut three times, and inserting a block is often clearer than repeatedly inserting single rows.

Using the ribbon or row-heading menu

The keyboard shortcut is quick, but the ribbon is useful when you are learning Excel, using a keyboard that lacks a convenient plus key, or troubleshooting a shortcut conflict. Select a cell in the target row, then choose Home > Insert > Insert Sheet Rows. This inserts a complete worksheet row above the row containing the active cell.

Another direct option is to right-click the numbered row heading and choose Insert. If you first select multiple row headings, the context-menu command inserts the same number of rows. This method makes the insertion point visible before you act and is less dependent on keyboard layout. The right-click menu can also offer related commands such as deleting the selected rows, so check that the intended row headings are highlighted.

These commands insert sheet rows, not just blank cells in a small selection. That distinction matters when a worksheet has values or formulas in several columns: adding a whole row keeps the sheet’s columns aligned. If you only need to make room within one part of a worksheet, use the cell-insertion command deliberately and review how Excel shifts neighboring cells.

Inserting rows in Excel for Mac and the web

In Excel for Mac, select the row and press Control+Shift+=. Keyboard layouts and Mac settings can affect how a plus sign is entered, so the row-heading menu or the Home ribbon is a reliable alternative if the shortcut does not respond. Do not substitute Command for Control without checking the shortcut for your Excel version; many spreadsheet shortcuts differ from familiar macOS shortcuts.

Excel for the web uses the same general idea: select a row and use its insert command. The browser or operating system may intercept some key combinations, and available shortcuts can vary with the browser. If the shortcut is ineffective, select the row heading and use the Insert command on the Home tab or the row’s context menu. The web app’s interface can differ slightly from the Windows desktop ribbon, but the result is still a new row above the selected row.

On all platforms, the row heading is a helpful visual check. If the entire numbered row is highlighted before you insert, you are asking Excel to add a worksheet row. If only one cell is highlighted, pause and select the row or choose the appropriate option in the Insert dialog.

What happens to data, formulas, and formatting?

When a row is inserted, existing rows below it move down. Excel generally adjusts references in formulas to account for the inserted cells, but the exact result depends on where the formula is located and what cells it refers to. For example, inserting a row within a referenced range commonly expands that range; inserting outside it may not. After a structural change in a complex workbook, check important totals, charts, named ranges, and formulas rather than assuming every reference behaves as intended.

The new row may inherit formatting from a neighboring row, and Excel can display an Insert Options control that lets you choose how the inserted row is formatted. The available choices depend on the surrounding cells and workbook. If the new row looks different from the rows around it, inspect its number format, borders, fill, and conditional formatting. You can also copy formatting from an appropriate neighboring row, but avoid copying its contents or formulas unintentionally.

In a structured Excel table, inserting a worksheet row and adding a table record are related but not identical actions. To add a record within a table, select a cell in the table and use the table’s row-insertion options or type in the row directly below the table. Table formulas and formatting can fill into new table rows automatically. If you intend to alter the worksheet’s overall row structure, use the worksheet row heading and confirm that the resulting table expands as expected.

Common shortcut problems and fixes

  • The Insert dialog opens: You probably selected a cell rather than the full row. Press Esc, select the row heading or use Shift+Space, then try again.
  • The key combination types a plus sign instead: Check that Ctrl is held on Windows and that you are using the equals key with Shift, or try the numeric keypad plus key. Keyboard layouts can change which key produces the symbol.
  • Nothing happens in Excel for the web: A browser may be using the key combination. Use the Home tab’s Insert command or right-click the selected row heading.
  • The wrong location changes: Excel inserts above the selected row. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then select the row below the intended insertion point.
  • The command is unavailable: The sheet may be protected, or workbook structure restrictions may prevent the change. Check the Review tab for protection options or ask the workbook owner for permission.
  • Rows seem to disappear: They may be hidden or filtered rather than deleted. Check the row numbers, clear or review filters, and inspect hidden rows before making further edits.

Undo is useful for a mistaken row insertion, but it is not a substitute for checking the selection first. In a shared workbook, changes may also be visible to other collaborators. If the workbook contains important data, verify the insertion point before editing and make sure you are working in the intended file.

Choosing the right insertion method

Use the shortcut when you are making a simple insertion and can clearly identify the target row. It is especially efficient when entering or cleaning data, because Shift+Space and Ctrl+Shift+= can be used without moving to the mouse. Use the ribbon or context menu when you want a visible command, are working on a Mac or in a browser with shortcut conflicts, or need to confirm that you are inserting entire rows.

Use the Insert dialog when you have selected cells rather than a complete row and genuinely need to choose how neighboring cells should shift. Use a table-specific row command when the task is to add a record to a structured table. These choices prevent a common mistake: inserting only a few cells in one column when the data is arranged as complete records across several columns.

For a repetitive task involving many separate insertion points, consider whether sorting, filtering, or restructuring the data would solve the underlying problem more safely. Inserting rows one by one can make formulas, references, and table boundaries harder to review. A clear data layout usually makes routine additions simpler.

Frequently Asked Questions

What is the Excel shortcut to insert a row above?
On Windows, select the row and press Ctrl+Shift+=. On Mac, select it and press Control+Shift+=. Excel inserts the new row above the selected row.

How do I select an entire row with the keyboard?
Click a cell in the row and press Shift+Space. Alternatively, click the row’s numbered heading. In a table, keyboard selection can behave differently because Excel may select a table row, so use the worksheet row heading when you need to be certain.

How do I insert multiple rows at once?
Select as many existing row headings as the number of rows you want to add, then use the insert shortcut or right-click and choose Insert. Excel adds that number of rows above the selected block.

Does Excel insert the new row above or below?
It inserts above the selected row. To add a row below a particular row, select the row immediately underneath it and insert there. At the bottom of a data list, you can also type in the first row below the list or use a table’s add-row behavior.

Why does Excel show an Insert dialog instead of adding a row?
Usually, only a cell or range was selected. Select the complete worksheet row first, using Shift+Space or its row heading, then invoke the shortcut again.

Can I undo an inserted row?
Yes. Use Ctrl+Z on Windows or Command+Z on Mac soon after the insertion. If you have made other changes since then, review the undo history or correct the worksheet carefully so you do not reverse unrelated work.

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.