Upper Menu

Quick Tip: Insert Several Rows in Excel Spreadsheets

Share Button

Ready for another time-saving Excel trick? Let’s say you wanted to insert several new rows. You don’t have to go Insert, Insert, Insert. You can do it all in one shot! Here’s how:

Highlight the number of rows that you want to insert and right-click on the row header. Then choose Insert, and Excel will insert that number of rows for you.

This also works for columns!

Watch me demonstrate how to insert several rows in Excel spreadsheets in this clip from my Learn Excel in 3 Hours Flat course.


If you want more Excel tips and tricks, take the full online course, Learn Excel in 3 Hours Flat, on Udemy.com. You’ll not only learn all the practical tools you’ll use on the job everyday, but also how to be more productive!

Act now and get the course for only $59 $49.

Take this Course

Related Posts

No comments yet.

Leave a Reply