Quickly Insert Multiple Rows in Excel [Tutorial]

Quickly Insert Multiple Rows in Excel. This tutorial will show you how you can quickly insert a single row in Excel by using a simple mouse shortcut.

This tutorial will apply for Microsoft Excel 2021, 2019, 2013, and 2010 for both Windows (such as Dell, HP, Lenovo, Samsung, Toshiba, Acer, Asus) and macOS (MacBook Air, MacBook Pro, MacBook Mini) devices.

[ubeevr]

What a stupid method implemented by Microsoft! It should be possible to simply select a row and specify the number of rows to be added. What if I need to add 100 rows?

[robfuzz]

or just hold down Shift while you drag and it'll be instant!

[ellenbarski]

Quick, easy, just what I needed. Thanks!

[stephanieplumb]

Thank you. How do you ensure the inserted rows copy down the formatting/formulas from above, please? I thought that Excel used to do this automatically, but it seems not to

[LeaJohnson]

Perfect, exactly the answer I was looking for!

[rahuljamba]

Thanks a lot for sharing your kneowledge

[mdjahangirhossain]

Quick, easy, just what I needed. Thanks a lot

[kamitik]

to the point, i'll leave a like for this

[lisareeves]

Have an Excel project and this video saved me tons of time. THANK YOU and God Bless

[Vk-rccq]

long time I was looking this option, Thank you.