Insert Row Shortcut in Excel | 3 Quick Shortcuts

In this quick tutorial we’ll learn how to use the excel shortcut to insert row quickly.

Insert Row in Excel Shortcut

Here is the quick shortcut to insert row.

Here’s an example of the same.
Select the row and use CTRL SHIFT + as the insert row shortcut in excel.

Make sure you select the entire row by selecting the row number.

Insert Row Shortcut in Excel for Multiple Rows

To insert multiple rows in excel quickly do this!

Select multiple rows then use CTRL SHIFT + shortcut to insert row.

This will add multiple rows. If you select 3 rows and use this shortcut, excel will insert 3 new rows. The more rows you select the more rows excel insert.

ATL+I+R Excel Shortcut to Insert Row

There is 1 more excel shortcut to insert row quickly which you can use.

Select the row and use ALT+I+R as the shortcut to insert row.

Do note that this shortcut might not work in some Excel versions.

Insert Row in Excel Shortcut to Open Insert Dialog Box

You can also insert row in excel by using the Insert Dialog Box, the shortcut for the same is as follows:

Select the cell where you want to insert a new row and use CTRL SHIFT +

The only difference is in selection. Instead of selecting the entire row, we have selected a single cell. The shortcut will open up the Insert Dialog Box, you can choose what to do- insert row, insert column and shift cells up or down.

Conclusion

I hope you liked the quick tutorial on how to insert row in excel using a shortcut.

If you have any questions or tips, I’d love to hear them in the comment section below.

Leave a Reply

Advanced Excel Course

Learn Vlookup, Pivot tables, What IF, Macro Automation, Power Query and much more.

  • 10+Hrs of Learning Content
  • 50+ Practical Exercises
  • Certification
  • Doubt Resolution
Eduolio.com | Copyright © 2021 | All Rights Reserved
Homepage Footer Logo
Eduolio.com | Copyright © 2021 | All Rights Reserved