This video shows you the quick tip for inserting a single row in Excel, by using a mouse shortcut.

Then see how to quickly insert multiple rows at once, using the same mouse shortcut

Watch more Excel data entry videos on my Contextures website.

http://www.contextures.com/xlDataEntry01.html

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra’s weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1

‘——–

VIDEO TRANSCRIPT

You can quickly insert rows in Excel by using a mouse shortcut.

So if I’d like a blank row between rows 3 and 4, I’ll right-click on the row 4 button and click Insert.

That puts one blank row above the row that I had selected.

I’ll just undo that.

Sometimes you want multiple rows inserted. So if I’d like four rows, I’m going to select four rows.

I’ll point to the first row button here, and just press the left mouse button and drag down.

And as I do, you’ll see a little button just below my pointer that tells me the number of rows I have selected.

Right now have four rows, which shows as 4R. If I went down one more, it would be 5R.

I want four. I’ll stop there and let go the mouse button.

Then right-click on any of those buttons and click Insert.

And there are the four blank rows.

‘——–

#ContexturesExcelTips

Please take the opportunity to connect and share this video with your friends and family if you find it useful.