Insert Row in Excel: Keyboard Shortcut for Windows

To insert a worksheet row in Excel for Microsoft 365 on Windows, select the row where the new one should go with Shift+Space, then press Ctrl+Shift+= (the plus key). Excel inserts a blank row above the selected row. You can also select several rows first to add that many blank rows at once. Save your workbook if needed before making a structural change, especially if it contains formulas or carefully arranged data.

This shortcut works because the first keystroke selects an entire row and the second tells Excel to insert rows above the selection. If you select only a cell instead, the insert command may show a dialog asking whether to shift cells or insert a full row. The instructions below explain both situations, how to insert multiple rows, and what to try if the shortcut does not work.

What You’ll Need

Excel for Microsoft 365 on Windows, with a workbook open and the worksheet where you want the row.
Permission to edit the workbook. A protected sheet or read-only file may prevent row insertion.
A keyboard with a plus key. On many keyboards, the plus sign is typed with Shift+=; a numeric keypad may have a separate plus key.

You do not need to select or copy existing data before inserting a blank row. If the worksheet is part of an Excel table, or is protected, read the relevant notes below because those situations can change the best way to add a row.

Step-by-Step

Open the correct worksheet. Click the sheet tab at the bottom of the workbook and locate the row that should appear immediately below the new blank row. For example, to add a row between current rows 8 and 9, select row 9. Inserting above the first row is also possible: select row 1 and use the same shortcut.
Select the row. Click a cell in the row that should move down, then press Shift+Space. The row number at the left should highlight, indicating that the whole worksheet row is selected. You can also click the row number directly, but the keyboard selection keeps the process entirely on the keyboard.
Insert the blank row. Press Ctrl+Shift+=. On a standard keyboard, hold Ctrl and Shift, then press the equals key (usually the key immediately to the left of Backspace); Shift makes that key produce the plus sign. If your keyboard has a dedicated numeric keypad plus key, Ctrl plus that key may also work. Excel adds a blank row above the selected row, and the previous contents move down.
Check where the row landed. Look at the row numbers and nearby entries. The new row should be between the row you selected and the row above it. If it appeared in the wrong place, press Ctrl+Z once to undo the insertion, select the correct row, and repeat the shortcut.
Enter or copy the new row’s contents. Click the first cell in the new row and type the needed values. If you want formulas or formatting like the row above, use the appropriate copy or fill method rather than assuming every blank row inherits the exact settings you need. Check formulas that refer to nearby ranges after adding a row.

To insert more than one row: select the same number of existing rows as the number you want to add. For example, to add three blank rows above row 9, select rows 9 through 11 by clicking row 9 and dragging down through row 11, or select row 9 and extend the selection with Shift+Down Arrow twice. Then press Ctrl+Shift+=. Excel inserts three rows above the selected block. The key principle is that the size of the selected row block determines the number of rows inserted.

If you selected just a cell: press Ctrl+Shift+= and Excel may open the Insert dialog. Choose Entire row, then confirm with Enter or click OK. This is useful when the active cell is in the intended insertion position but you have not selected the complete row. If the dialog offers other choices, such as shifting cells right or down, choose Entire row when you want a new worksheet row across all columns.

Ribbon alternative: select the target row, then choose Home > Insert > Insert Sheet Rows. You can also use the Windows ribbon key sequence Alt+H, I, R: press the keys in order, rather than holding them all together. This is a useful fallback if a keyboard layout makes the plus shortcut awkward, or if another program intercepts it.

On a Mac: the exact key combination depends on the keyboard and Excel version. In many Excel for Mac setups, select the row with Shift+Space, then use Control+Shift+= to insert. If that combination does not work, use the ribbon command Home > Insert > Insert Sheet Rows or the available Insert command in your version. On Excel for the web, shortcut behavior can depend on the browser and keyboard; use the Home ribbon if the shortcut is intercepted.

Common Mistakes

Selecting the wrong row: the inserted row goes above the selection, not below it. If you want a blank row between rows 8 and 9, select row 9. A common slip is to select row 8 because it is the last row above the intended space; that places the new row above row 8 instead.

Pressing Ctrl+= without Shift: on a typical Windows keyboard, the plus sign shares the equals key, so you must hold Shift as well as Ctrl. The intended shortcut is Ctrl+Shift+=. A dedicated numeric keypad plus key may allow Ctrl plus that key instead, but keyboard behavior can vary.

Selecting only a cell and choosing the wrong option: when Excel displays the Insert dialog, choosing Shift cells down affects only part of the worksheet. Choose Entire row if you need a full worksheet row. This matters when columns beyond your visible data contain notes, formulas, or other content.

Confusing a worksheet row with a table row: a formatted Excel table is a structured range with its own row behavior. To add a record to a table, click a cell in its last row and press Tab from the last cell to create a new table row. You can also use the table’s row insertion options. Inserting an entire worksheet row is a broader change, so use it only when you intend to shift the sheet’s rows, not merely add a record to the table.

Forgetting filters, hidden rows, or merged cells: a filtered or hidden worksheet can make the selected row less obvious, and merged cells can complicate editing around the selection. Check the row number highlight before inserting. If the result is unexpected, undo immediately and review the selection and filter state.

Tips

Use the row numbers to verify selection. After Shift+Space, the row number should be highlighted and the selection should span the worksheet. If only one cell is outlined, the whole row is not selected. This quick visual check prevents inserting a few shifted cells when you meant to add a complete row.

Insert a block in one action. Selecting three rows and inserting once is generally clearer than repeating the shortcut three times. It also makes it easy to control exactly how many blanks appear. Select the rows immediately below the intended insertion point, because Excel places the new block above them.

Use undo as a safety net, not a substitute for checking. Ctrl+Z reverses a recent insertion in most ordinary worksheets. Confirm the result before doing more editing, since later actions may make it harder to identify or undo the change you meant to reverse. If the workbook is shared or contains important data, consider saving a copy first.

Consider formula and formatting behavior. Excel often adjusts references in formulas when rows are inserted, but the result depends on the formula and where the row is added. Review totals, charts, named ranges, and formulas that use fixed ranges. Formatting can come from adjacent rows or follow Excel’s insertion options; inspect borders, number formats, and data validation before entering a large batch of information.

Know when to add a table record instead. If your data is an Excel table and you are adding one new record, use the table’s final cell and press Tab. Excel extends the table and usually carries its formatting and calculated-column formulas into the new record. A worksheet-row insertion is more appropriate when you need space across the sheet, including outside the table.

Troubleshooting

The shortcut types a plus sign or does nothing: first confirm that the row, rather than a cell in edit mode, is selected. Press Esc if you are editing cell contents, then use Shift+Space. Try Ctrl+Shift+= using the equals key, or use the numeric keypad plus key if available. Laptop keyboards may require an Fn key for keypad functions; the ribbon command is a reliable alternative.

Excel opens an Insert dialog instead of inserting immediately: this is normal when you have selected a cell rather than a complete row. Choose Entire row and confirm. If you intended to insert one full row without a dialog, close the dialog, select the row with Shift+Space, and repeat the shortcut.

The row is inserted in the wrong position: press Ctrl+Z immediately. Remember that Excel inserts above the selected row. Select the row that currently sits below the desired blank space, then try again. For a row at the bottom of existing data, select the next row below the data before inserting.

The Insert command is unavailable: the sheet may be protected, the workbook may be read-only, or editing may be restricted by sharing or permissions. Check Review > Unprotect Sheet if you have permission and the sheet is protected. If the file is read-only, save an editable copy or ask the owner for access. Do not try to bypass protection without authorization.

The command affects a table or filtered data unexpectedly: undo the change and decide whether you need a worksheet row or only a table record. For a table record, add a row within the table using its last cell and Tab, or use the table’s insertion controls. With filtered data, confirm which visible row is selected and whether you intend to affect the underlying worksheet row structure.

The shortcut differs on your Mac or in a browser: keyboard layouts, browser shortcuts, and Excel builds can affect key combinations. Use the Home ribbon’s Insert Sheet Rows command as a version-independent fallback where available. If using Excel for the web, check that the browser has not captured the shortcut for another purpose.

Frequently Asked Questions

What is the keyboard shortcut to insert a row in Excel?
On Windows, select the row with Shift+Space, then press Ctrl+Shift+=, which types the plus-key command. With a row selected, Excel inserts a blank row above it.

How do I insert a row below the current row?
Select the row that currently sits below the place you want the blank row. Excel inserts above the selection. For example, select row 10 to insert a new row between rows 9 and 10.

Can I insert several rows at once?
Yes. Select as many worksheet rows as you want to add, starting at the row that should move down, and use the shortcut once. Selecting four rows inserts four blank rows above that selection.

Can I insert a row without using the mouse?
Yes. Move to a cell in the target row, press Shift+Space to select the whole row, and then press Ctrl+Shift+=. You can also use the Windows ribbon key sequence Alt+H, I, R.

Why does Excel ask whether to shift cells or insert an entire row?
You likely selected a cell rather than a whole row. Choose Entire row for a full worksheet row, or cancel and select the row with Shift+Space before using the shortcut.

Does this shortcut add a row to an Excel table?
It can affect worksheet rows around a table, but for a simple new table record, move to the last cell in the table and press Tab. That adds a table row and is usually the more appropriate choice.

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.