Excel Insert Row Shortcut: Fast Ways for Windows and Mac

Excel has no built-in shortcut named “IR.” If you mean insert row, select the row with Shift+Space, then press Ctrl+Shift+= on Windows (the plus key). On a Mac, use Control+Shift+=. The selected row is where Excel adds a blank row above.

What “IR” Means in Excel

“IR” is not a standard Excel command or a universal abbreviation for a keyboard shortcut. People often use it informally to mean “insert row,” or type it as shorthand when searching for the insert-row shortcut. Excel does not have a single key sequence that spells I-R and inserts a row. The shortcut uses the plus sign, and the result depends on what you have selected.

That selection matters because Excel uses the same insert command for different things. If you select a whole worksheet row, it inserts a worksheet row. If you select a cell or a group of cells, Excel may display an Insert dialog so you can choose whether to shift cells down or right, or insert an entire row or column. Selecting the full row first makes the intended action clear.

For example, if you need a blank row above row 8, click a cell in row 8, press Shift+Space to select the whole row, then use the insert shortcut. The new blank row appears at row 8, and the old row 8 and rows below it move down.

Insert a Row with the Windows Shortcut

In Excel for Microsoft 365 on Windows, use this sequence to insert one worksheet row without reaching for the ribbon:

Click any cell in the row that should move down.
Press Shift+Space to select the entire worksheet row.
Press Ctrl+Shift+=. On a standard US keyboard, the plus sign is made with Shift and the equals key.

Excel inserts a blank row immediately above the selected row. So, if row 8 is selected, the new row becomes row 8; existing row 8 becomes row 9. The shortcut is sometimes written as Ctrl++ or Ctrl+Plus. These notations describe the same action, but Ctrl+Shift+= is often easier to follow on a keyboard where plus shares the equals key.

You can also select the row by clicking its number along the left edge of the sheet, then press the shortcut. This is useful when the row is far across the screen or you want to confirm exactly which row is selected. To insert several rows at once, select the same number of complete rows first. For instance, selecting rows 8 through 10 and using the shortcut inserts three blank rows above row 8.

Why Selecting the Whole Row Matters

The shortcut does not always insert an entire row just because you intend it to. If only a cell is selected, Excel may open the Insert dialog. The dialog offers choices such as shifting cells down, shifting cells right, inserting an entire row, or inserting an entire column. Choose “Entire row” when that is what you want, then confirm.

For a quick, predictable result, select the row before issuing the shortcut. Use Shift+Space while the active cell is in the target row, or click the row number. A selection spanning several cells in one row is not always the same as selecting the full worksheet row; the row header becomes highlighted when the whole row is selected.

There is an important exception: a range inside an Excel Table has table-specific behavior. A table is a formatted data object with its own headers and filters. To add a record within a table, right-click a cell in the table row and choose Insert > Table Rows Above. This adds a table row while preserving the table structure. Inserting a worksheet row outside the table, or using a selection that includes full sheet rows, can have a broader effect than adding one record to the table.

Use the Ribbon or Right-Click Menu

If you cannot remember the key combination, Excel’s ribbon provides a dependable alternative. Select the row or a cell in it, then choose Home > Insert > Insert Sheet Rows. Excel inserts a blank worksheet row above the selected row. The ribbon option is particularly helpful when keyboard layouts make the plus-key combination awkward.

You can also right-click the row number and choose Insert. If you right-click an ordinary cell rather than the row header, Excel may show an Insert dialog instead, because it cannot assume whether you want to shift cells, rows, or columns. The row-header menu is a straightforward choice when you want a whole worksheet row.

These methods produce the same basic result for a regular worksheet. Choose the shortcut for speed when you are editing repeatedly, the ribbon when you want a clearly labeled command, or the row-header menu when you are already using the mouse to select the target.

Differences on Mac and in Excel for the Web

In Excel for Mac, the usual insert shortcut is Control+Shift+=, with the target row selected. This differs from many Mac shortcuts that use the Command key: for inserting rows, the Control key is the relevant modifier in Excel. Keyboard layouts and system settings can affect which key combination is convenient, so the ribbon command is a useful fallback.

Excel for the web also offers the ribbon route: select the row and use Home > Insert > Insert Sheet Rows. Keyboard shortcuts can be affected by the browser, operating system, and keyboard layout, so if the Windows-style shortcut does not behave as expected in a browser, use the ribbon or right-click the row header. The Insert menu may also look slightly different depending on the available screen width.

On either platform, the core idea is the same: select the whole row that should move down, then insert. When following instructions written for another operating system, check the named modifier key rather than assuming that Ctrl and Command are interchangeable.

Common Problems and How to Fix Them

The Insert dialog appears. You probably selected cells rather than a whole worksheet row. Close the dialog, select the row with Shift+Space, and try again, or choose Entire row in the dialog.
The wrong row was inserted above. Excel inserts above the selected row, not below it. Select the row that should move down. To add a row below the last item in a list, select the row immediately below the list and insert there.
The shortcut does nothing or types a character. Check that Excel has focus, that a cell is selected, and that you are pressing the plus combination rather than an unrelated key. On a different keyboard layout, try the ribbon command.
The row seems to be missing. Check whether the sheet is filtered, rows are hidden, or the view is scrolled. A newly inserted row can be hidden by an existing filter or by hidden-row settings, even though Excel has added it.
Excel says it cannot insert more cells. A worksheet may have formatting or other content near its bottom or right edge, making Excel treat the used area as too large to shift. Inspect the far end of the sheet and remove genuinely unnecessary content or formatting before trying again. Save a copy first if cleaning up a workbook with important data.

For a workbook shared with others, also consider whether the sheet is protected. Protection can prevent row insertion unless the sheet’s protection settings permit it. If the command is unavailable or Excel reports a protection restriction, ask the workbook owner or review Review > Protect Sheet rather than trying to work around access controls.

Undo, Insert Columns, and Related Shortcuts

If you inserted a row by mistake, use Ctrl+Z on Windows or Command+Z on Mac immediately. Undo reverses the insertion as long as it remains in the undo history. If you have made several changes since inserting the row, review the workbook before undoing a long chain of actions, because each undo step can reverse a different change.

The same selection principle applies to columns. Select a cell in the column that should move right, press Ctrl+Space to select the whole column, and use the insert shortcut. On a Mac, use the corresponding Control-based insert combination. Excel places the new blank column to the left of the selected column. If the shortcut is inconvenient, choose Home > Insert > Insert Sheet Columns.

For routine data entry, you may not need to insert a worksheet row manually each time. In an Excel Table, typing into the row immediately below the table can expand the table to include the new record, subject to the workbook’s settings and layout. This keeps formulas and table formatting aligned more naturally than adding unrelated sheet rows. For a small, ordinary range that is not a table, inserting a blank row remains a simple way to make space between existing records.

Frequently Asked Questions

What is the Excel shortcut to insert a row?

Select the target row, then press Ctrl+Shift+= on Windows. On Mac, use Control+Shift+=. Excel inserts a blank row above the selected row.

How do I insert a row without using the mouse?

Move to a cell in the target row, press Shift+Space to select the whole row, then press the insert shortcut. On Windows, that is Ctrl+Shift+=; on Mac, it is Control+Shift+=.

Can I insert more than one row at once?

Yes. Select the number of complete rows you want to add, starting at the row where the new rows should begin, then use the shortcut. Selecting three rows inserts three blank rows above the first selected row.

Does Excel have an “IR” keyboard shortcut?

No standard Excel shortcut is named IR. If you mean insert row, use the plus-key shortcut with a whole row selected, or choose Home > Insert > Insert Sheet Rows.

How do I insert a row inside an Excel Table?

Right-click a cell in the table row where the new record should go and choose Insert > Table Rows Above. This adds a row to the table rather than relying on a worksheet-wide row insertion.

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.