How to Insert a Row in Excel Without a Mouse: Shortcuts

To insert a row in Excel without a mouse, move to a cell in the row that should shift down, press Shift+Space to select the row, then press Ctrl+Shift+= on Windows. Excel inserts a blank row above it. You can also use the ribbon from the keyboard, or use the equivalent shortcut on a Mac.

What You’ll Need

A keyboard and an open Excel workbook. These steps are for Excel for Microsoft 365 on Windows unless noted otherwise.
A cell position to use as a reference: the inserted row goes above the row containing the active cell or selected row.
If the workbook is protected, permission to make structural changes. A protected sheet may prevent row insertion even when the shortcut is correct.

Step-by-Step

Choose where the new row should go. Excel inserts a row above the current row, not below it. For example, to add a blank row between rows 6 and 7, go to any cell in row 7. The existing row 7 and the rows below it will move down. If you want a row at the bottom of a list, use the current last row as your reference so the new row appears above it, or add a row after the list using the appropriate table or sheet method.
Move to a cell in the target row. Use the arrow keys to navigate from the current selection. You can also press Ctrl+G, type a cell reference such as A7 in the Go To box, and press Enter. This is useful in a long worksheet where scrolling with the keyboard would take time. The column does not matter; the row number does.
Select the entire worksheet row. Press Shift+Space. Excel highlights the full row, and the row number at the left is included in the selection. Check that the highlight covers the row you intend to move down. If the active cell is in row 7, for instance, row 7 should be selected before you continue.
Insert the blank row. Press Ctrl+Shift+=. The equals key shares the plus key on many keyboards, so hold Ctrl and Shift while pressing it. If your keyboard has a separate numeric keypad plus key, Ctrl plus that key may work as well. Excel inserts one worksheet row above the selected row and leaves the new row selected.
Insert several rows at once, if needed. First select the same number of complete rows as the number of blank rows you want. For example, to insert three rows above row 7, go to row 7, press Shift+Space, then extend the selection to two adjacent rows with Shift+Down twice. Confirm that exactly three full rows are highlighted, then press Ctrl+Shift+=. Excel inserts three rows above the selection. The existing rows shift down; their contents are not overwritten.
Use the ribbon key sequence as an alternative. On Windows, select a cell in the target row, then press and release Alt, H, I, and R in sequence. These are ribbon Key Tips for Home > Insert > Insert Sheet Rows. You do not hold all four keys together. This command inserts a whole sheet row above the active cell’s row, so you do not need to select the row header first.
Check the result before typing. Use the arrow keys to inspect the new blank row and the rows immediately above and below it. Confirm that the intended records moved down together and that formulas, labels, and formatting remain where expected. If the insertion was accidental, press Ctrl+Z immediately to undo it, provided you have not performed an action that clears Excel’s undo history.

Mac: The row-selection shortcut is also Shift+Space. To insert the selected row, use Control+Shift+= on many Mac keyboards; the plus sign may require Shift with the equals key. Keyboard layouts and Excel settings can differ, so if that combination does not work, use Excel’s menu or ribbon with the keyboard and choose the row-insertion command. The Windows Alt, H, I, R Key Tip sequence is not the Mac equivalent.

Excel for the web: Try the same row-selection and insert shortcut if your browser and keyboard allow Excel to receive it. Browser shortcuts can intercept some key combinations. If that happens, use the ribbon: move keyboard focus to the ribbon, open the Home tab’s Insert menu, and choose the option for inserting sheet rows. The exact menu wording can vary slightly by interface and update.

Common Mistakes

Choosing the wrong reference row. The new row appears above the active row. If you select row 6 when you meant to insert between rows 6 and 7, the blank row appears before row 6. Move to row 7 first for the intended position.
Selecting a cell rather than a whole row. If you press Ctrl+Shift+= with just one cell selected, Excel may open the Insert dialog instead of immediately adding a sheet row. Use Shift+Space first when you want a complete row.
Using the wrong plus-key combination. On a standard keyboard, plus is usually the shifted equals key. Press Ctrl+Shift+=, not Ctrl and the equals key alone. The exact physical key can differ on compact or non-US layouts.
Selecting too many or too few rows. Excel inserts as many rows as you have selected. Before the shortcut, verify the highlighted row count, especially if you used Shift with an arrow key to extend the selection.
Confusing a sheet row with a table row. A formatted Excel table has its own structure and may expand as you insert rows next to it. If you only need another record at the end of a table, moving to its last cell and pressing Tab is often the simplest keyboard-only option. That adds a table row rather than placing a blank worksheet row at an arbitrary position.
Expecting the row to appear below the selection. The standard insert command places new rows above the selected row. To put a blank row after a particular record, select the row beneath that record before inserting.

Tips

Use Go To for distant rows. Press Ctrl+G, enter a reference such as D250, and press Enter to jump directly to row 250. Then select or insert at that location. This avoids holding an arrow key for a long time.
Repeat an insertion efficiently. If you need several separated blank rows, insert one at each location and recheck the row numbers as they shift. For a block of adjacent blanks, selecting several complete rows once is quicker and reduces the chance of inserting the wrong count.
Keep related data together. If a record uses several columns, insert an entire sheet row rather than inserting cells in only one column. This keeps names, dates, amounts, and other fields aligned. A single-cell insertion can shift part of a record and leave the worksheet inconsistent.
Use undo as a safety net. If a row lands in the wrong place, press Ctrl+Z on Windows or Command+Z on Mac promptly. Check the workbook before continuing. Undo is not guaranteed to be available after every action, and it cannot restore changes made after the undo history is cleared.
Consider filters and hidden rows. When a filter is active, visible records may not be consecutive worksheet rows. Inserting a whole sheet row affects the underlying worksheet position, not merely the next visible record. If the exact location matters, clear or review the filter and verify the row numbers before inserting.
Protect your structure in shared files. In a workbook used by others, confirm that adding a sheet row will not disrupt a carefully arranged report, print layout, or references outside the visible area. Excel generally adjusts many references when rows are inserted, but review key totals and linked sheets after structural edits.

Troubleshooting

The shortcut opens a dialog. This is expected when Excel has a cell or partial range selected. In the Insert dialog, use the arrow keys to choose Entire row, then press Enter. Alternatively, close the dialog, go back to the target row, press Shift+Space, and retry the insertion shortcut.
Nothing happens when you press the shortcut. Check that Excel, rather than another application or a browser control, has keyboard focus. On Windows, try the sequential Alt, H, I, R command. If the keyboard has a different layout, use the Home tab’s Insert command with keyboard navigation instead of relying on the plus-key position.
Excel says it cannot shift cells or rows. The worksheet may have content or formatting at the bottom edge, or the insertion could push data beyond Excel’s row limit. Inspect the last used rows and remove genuinely unnecessary content or formatting only after confirming it is safe. Then try again. Avoid deleting whole areas of a shared sheet without checking what they contain.
The sheet is protected. A protected worksheet can block row insertion. Ask the workbook owner for permission or an unprotected copy. If you are authorized to change the sheet, use Review > Unprotect Sheet and provide the password if prompted. Do not try to bypass protection on a workbook you are not permitted to edit.
The new row appears in an unexpected place. Undo once, then check the active cell’s row number. The insertion position follows the active row or selected rows, not necessarily the cell you last looked at. Jump to the intended row with Ctrl+G, select it, and insert again.
The table changes differently than expected. Determine whether the selection is inside an Excel table or on the surrounding worksheet. For a new record at the bottom of a table, use Tab from the last cell in the last table row. For a whole worksheet row, select the worksheet row and use the sheet-row command, then confirm how the table and nearby content adjusted.
A shortcut behaves differently on Mac or in a browser. Operating systems, keyboard layouts, and browsers can reserve key combinations. Use Excel’s own menu or ribbon with keyboard focus and select the explicit row-insertion option. This avoids relying on a shortcut that the system may intercept.

Frequently Asked Questions

What is the fastest keyboard shortcut to insert a row in Excel?
On Windows, move to the target row, press Shift+Space to select it, then press Ctrl+Shift+=. The blank row appears above the selection.

Can I insert a row without selecting the entire row first?
Yes. With a cell selected, press Ctrl+Shift+= and choose Entire row in the Insert dialog. Selecting the whole row first is usually faster when you know you want a complete worksheet row.

How do I insert two or more rows at once?
Select the same number of complete adjacent rows as the number of rows you want to add, then use the insert shortcut. Selecting four rows inserts four blank rows above the selected block.

Does Excel insert the new row above or below?
It inserts above the active row or selected rows. To add a row between rows 10 and 11, select row 11 before inserting.

What is the Mac shortcut for inserting a row?
Select the row with Shift+Space, then try Control+Shift+=. Depending on the Mac keyboard layout, the plus sign may require Shift with the equals key. If the shortcut is intercepted, use Excel’s row-insertion command from the menu or ribbon.

Will inserting a row change my formulas?
Excel adjusts many formulas and cell references when you insert a worksheet row, but you should check important totals, charts, and formulas on other sheets afterward. References to data outside the inserted area or formulas using fixed text-based references may need separate review.

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.