Insert Row Shortcut in Excel on Mac (Alt + I R)

💡
Quick Answer

The Excel 2003 insert row shortcut is Alt + I R. It adds a full row above the selected cell. On a Mac, install Accelerator Keys, select a cell, then press Option, then I, then R. Select three rows first to insert three rows.

Download Accelerator Keys for Free Now

If you are looking for the insert row shortcut in Excel on Mac, Alt + I R is the one many Windows users know from Excel 2003. Windows Excel still accepts it. With Accelerator Keys, it works on your Mac too.

What Does Alt + I R Do?

Alt + I + R is the legacy shortcut for Insert > Rows. It inserts full rows above the selection. Excel inserts the same number of rows as you select. Rows below move down.

Legacy vs. Modern Shortcut Comparison

Shortcut Era Menu Path
Alt + I + R Legacy (Excel 2003) Insert > Rows
Alt + H + I + R Modern (Ribbon) Home > Insert > Insert Sheet Rows

Both shortcuts work with Accelerator Keys.

How It Works on Mac

On your Mac, Accelerator Keys runs Insert > Rows in the Excel menu bar. It works on any ribbon tab and at any window width.

Step-by-Step: How to do Alt + I R on Mac Excel

  1. Install the Fix: Download Accelerator Keys (14-day free trial, no credit card required).
  2. Select the rows: Select a cell, or select as many rows as you want to insert.
  3. Press Option: Press the Option key. It works like Alt on Windows.
  4. Press the letters one at a time: Press I, then R.
  5. Result: Excel inserts the new rows above the selection.

Frequently asked questions

Does Alt + I R work natively on Mac Excel?

No. Excel for Mac’s own KeyTips do not support the legacy Alt + E, Alt + I, Alt + O, and Alt + D menu keys. Accelerator Keys adds them. Press Option, then I, then R.

How do I insert more than one row?

Select the same number of rows that you want to insert. For example, select three rows, then press Option, then I, then R. Excel inserts three rows above them.

What is the modern equivalent of Alt + I R?

The modern ribbon shortcut is Alt + H + I + R (Home > Insert > Insert Sheet Rows). Both work on Mac with Accelerator Keys.

Related Links