Keyboard shortcut to insert a row in Excel

Excel 2013

  1. Shift+Spacebar to select the row.

  2. Alt+I+R to add a new row above.

Excel 2016

  1. Shift+Spacebar to select the row.

  2. Alt+I+R to add a new row above.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!