Shortcut keys
WindowsCtrl + Shift + +
MacCmd + Shift + +
Ribbon path
Home → Insert → Insert Sheet Rows
What it does
Inserts a new blank row above the selected row. Select multiple rows first to insert the same number of rows.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for insert row?
On Windows, use Ctrl + Shift + +. On Mac, use Cmd + Shift + +.
Where is insert row in the Excel Ribbon?
The Ribbon path is Home → Insert → Insert Sheet Rows.
What does insert row do in Excel?
Inserts a new blank row above the selected row. Select multiple rows first to insert the same number of rows.