How to Delete Blank Rows in Excel

Often you will receive a spreadsheet with information organised in a table but with blank rows.

How do you delete blank rows in Excel quickly and easily?

[maggiemondo]

Completely brilliant. Always wondered how to do this and now I can. Thank you so much for this Aldo.

[OM_SriSaiRam]

Your video has helped a lot ... thanks for sharing

[tammystaveley]

Thank You...Thank You! Needed a little "it's easy" today & you made it so:)

[ahmedfaizan]

Short and to the point. Excellent video

[PoultryIndiatvrates]

Thanks From India. The easy way you adopt to teach, takes few seconds to Learn /complete the task Immediately.

[kathyaguilar]

Thank you! This method is just what I was looking for.

[lindah]

Thank you much! Your method works well in my current MS Office Excel program. Many others don't work as well in my experience.

[sahilmujbaile_]

Very useful video aldo thank you and very specific and time saving content keep the good work.

[Ext-]

Carefully explained! Thank you soo much XLNinja!

[ryanrite]

Thanks for this video! This just helped me A LOT!

[bahodireshchanov]

This video saved my life. Thank you very much!!!

[Varadi]

A million thanks to you...this method saved my time.

[harvindrasingh]

very informative and helpful video.. within seconds I found answer of my query ... Thanks Aldo...

[taposdas]

Thank you very much for sharing. Had been doing this manually for many months. Was driving me crazy.

[xttkpgw]

Awesome, simple yet Helped me to save time! Thankss

[bhavananotla]

Great video it was so helpful and made the work easy, thank you for the video ☺️

[ROMON]

Most accurate video ever, no other content, 👍

[jaccohaaksema]

amazing guide! saved me a lot of time :)

[Chris-jiiu]

Nice! Direct and to the point. Thank you.

[sudeeshsukumaran]

You made my work so easy. Thanks a lot..