Excel Shortcut to Insert a Row: Windows and Mac

How-to basics · Updated November 20, 2026

Yes. In Excel for Microsoft 365 on Windows, select the row where the new one should go, then press Ctrl+Shift+= (the plus sign). Excel inserts a blank row above the selected row. If you have selected only a cell, the same shortcut opens the Insert dialog, where you can choose Entire row.

The quickest way to insert a row

For a single worksheet row, the shortcut is fastest when you select the whole row first. Click its numbered heading at the left of the worksheet, or click a cell in the row and press Shift+Space to select that row. Then press Ctrl+Shift+=. The new row appears above the selection, and existing rows below move down.

The plus sign on most standard keyboards shares the equals key. That means the physical keystrokes are usually Ctrl, Shift, and = together. On some keyboards, the numeric keypad plus key works with Ctrl as well. If your keyboard layout makes the shortcut awkward, use the ribbon or right-click menu instead.

  • Insert above: select the row that should move down, then use the shortcut.
  • Insert below a particular row: select the row immediately beneath it, then insert above that selection.
  • Insert at the top: select row 1 and insert; the existing first row moves down.

What the shortcut does—and why selection matters

Excel needs to know whether you mean a whole worksheet row or just a few cells. When a complete row is selected, the shortcut inserts a complete row. When only one cell or a range of cells is selected, Excel may show the Insert dialog so you can choose how to shift the surrounding cells. That distinction helps prevent an accidental change to only part of a table of data.

For example, suppose a list has headings in row 1 and its first record in row 2. If you select row 2 and insert, the blank row appears between the heading and the first record. If you want a new record at the bottom of the list instead, inserting a worksheet row in the middle is usually not necessary; add the record beneath the existing data or use the table-specific method described below.

Inserting a row does not simply place an empty line over existing data. Excel shifts the affected worksheet cells downward to make room. Formulas that refer to moved cells are generally adjusted by Excel, but inserting rows can still change the layout, range boundaries, or formulas in a complex workbook. Check important totals and references after making structural changes.

Step-by-step: insert one row above a selected row

  1. Find the row number at the left edge of the worksheet where the blank row should appear.
  2. Click that row number to select the entire row. Alternatively, select a cell in it and press Shift+Space.
  3. Press Ctrl+Shift+=. On a standard keyboard, hold Ctrl and Shift while pressing the equals key.
  4. Confirm that the new blank row is above the row you selected and that the existing data has moved down.

It is worth checking the selection before pressing the shortcut. A highlighted row number indicates that the whole worksheet row is selected. A highlighted block of cells instead may mean the shortcut will offer choices about inserting cells, rather than immediately inserting an entire row.

Insert several rows at once

You can insert multiple adjacent rows in one operation. Select the same number of existing rows as the number of blank rows you want, then use the shortcut once. For instance, to add three rows above row 8, select rows 8 through 10 by dragging across their row headings or by selecting a cell in row 8 and extending the selection through row 10. Press Ctrl+Shift+=. Excel inserts three rows above the selected block.

This method is usually quicker and less error-prone than repeating the shortcut three times. Repeated insertions can change which row is selected or make it easier to insert at the wrong position. To select a range using the keyboard, click a cell in the first row, hold Shift, and select a cell in the last row; then make sure the intended rows are highlighted before inserting.

You can also select nonadjacent rows, but inserting in that situation may produce a result that is less obvious and can depend on the selection. For predictable placement, select one continuous block of row headings. If the worksheet contains filtered data, take extra care: a visible row selection and the underlying worksheet rows may not correspond to the records you intend to change.

Use the ribbon or right-click menu instead

If you cannot remember the shortcut, or the keyboard behaves differently on your device, Excel has menu commands for the same task. Select the row or rows, then use Home > Insert > Insert Sheet Rows. The command inserts worksheet rows above the selection. You can also right-click a selected row heading and choose Insert.

On Windows, the ribbon KeyTip sequence is commonly Alt, H, I, R: press the keys in sequence rather than holding them all together. KeyTips are the letter or symbol prompts Excel displays after you press Alt. If the prompts in your version differ, follow the labels shown on screen or use the visible ribbon command. The right-click method is useful when you are already selecting row headings with a mouse.

When only a cell is selected, the Insert command can open choices for shifting cells, inserting a row, or inserting a column. Choose the option that matches the layout you need. If you want a full worksheet row, selecting its row heading first is the clearest way to avoid inserting only a smaller group of cells.

Worksheet rows and Excel table rows are different

A worksheet row runs across the sheet and has a number at its left. An Excel table is a structured data range with features such as header filters and automatic expansion. If your selection is inside a table, inserting a whole worksheet row can affect cells outside the table too. That may be appropriate when you need space across the sheet, but it is not always the best way to add a record to the table.

To add a row within a table, right-click a cell in the table row where the new record should be placed and choose Insert > Table Rows Above. This adds a table row above that table record without treating the operation as merely a new record at the bottom. To add a record at the end of a table, you can usually type in the row immediately below it; the table expands when the adjacent data is entered. Pressing Tab from the last cell of the table’s last row also creates a new table row.

Use the table-specific command when you want the new line to belong to the table, so it participates in table formatting, filters, and structured references. Use Insert Sheet Rows when you mean to add space across the worksheet. If a workbook has formulas or data beside the table, check those neighboring cells before choosing a whole-sheet insertion.

Windows, Mac, and Excel for the web

This article gives the Windows shortcut first: select a full row and press Ctrl+Shift+=. In Excel for Mac, the corresponding insert shortcut is generally Control+Shift+= after selecting the row. Mac keyboard layouts and external keyboards can affect how the plus sign is entered, so if the keystroke does not work, use the menu command: select the row, then choose Home > Insert > Insert Sheet Rows.

Excel for the web also has insert commands on the Home tab and in the row-heading context menu. Keyboard shortcuts in a browser can sometimes be intercepted by the browser or differ with the operating system and keyboard layout. If the desktop shortcut does not behave as expected in the web version, select the row heading and use the on-screen Insert command. The result is still a worksheet row inserted above the selected row.

Common problems and how to fix them

  • The shortcut opens a dialog. You probably selected a cell or a cell range rather than an entire row. Choose Entire row in the dialog, or cancel, select the row heading, and try again.
  • The row appeared in the wrong place. Excel inserts above the selected row, not below it. Select the row immediately below your intended insertion point before using the command.
  • The shortcut seems not to work. Check whether another window, add-in, keyboard layout, or browser is intercepting the keystroke. Try the ribbon command or right-click the row heading.
  • Only part of the data moved. You may have inserted cells rather than a worksheet row. Undo promptly with Ctrl+Z on Windows, then select the row number and insert again.
  • The new row has unexpected formatting. Excel may carry formatting from a neighboring row. Use the Insert Options button that appears near the inserted area, if available, to choose how formatting is applied, or adjust the new row with the Home tab’s formatting tools.

A filtered list deserves special attention. Filtering hides records; it does not remove them from the worksheet. Inserting a worksheet row while working in a filtered range may place a row in the sheet structure rather than simply adding a visible record to the list. For a table, use its table-row insertion command or add a record at the table’s end, then verify that the new record appears as expected when the filter is applied.

Undo, formatting, and workbook checks

If you inserted a row by mistake, press Ctrl+Z on Windows or use the Undo command in Excel. Undo is the simplest fix immediately after the insertion, before making other edits. If you have already performed several actions, check the Undo menu so you understand which changes will also be reversed.

Inserted rows may inherit formatting from nearby rows, and formulas in adjacent ranges may extend or adjust depending on the workbook structure. In a simple list, this often works as intended. In a workbook with merged cells, subtotals, named ranges, charts, or formulas tied to fixed positions, review the affected area after inserting. This is not a reason to avoid the shortcut; it is a reminder that row insertion changes the sheet’s structure, not just its appearance.

For shared or business-critical workbooks, consider saving a copy before making substantial layout changes. A single inserted row is normally easy to undo, but checking the surrounding formulas, table boundaries, and print layout can catch issues that are not obvious from the new blank line alone.

Frequently Asked Questions

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

How do I insert a row below the selected row?
Excel inserts above the selection. Select the row immediately below the place where you want the new row, then use the shortcut.

Can I insert more than one row at a time?
Yes. Select as many adjacent row headings as the number of rows you want to add, then use Ctrl+Shift+= once.

What is the Mac shortcut for inserting a row in Excel?
In Excel for Mac, select the row and press Control+Shift+=. If your keyboard layout makes that difficult, use Home > Insert > Insert Sheet Rows.

Why does Excel show an Insert dialog instead of adding a row?
The selection is likely a cell or cell range rather than a complete row. Select the row heading first, or choose Entire row in the dialog.

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.