How to Delete Blank Rows in Excel

In this video we look at 3 WAYS to delete blank rows in Excel with Filters, Formulas, and a VBA Macro. These techniques focus on deleting or removing entire blank rows from a worksheet.

This is a common task for exported reports, and we need ways to delete the blank rows quickly.

I explain how to filter for blanks, how to create a column of COUNTA formulas to count all the cells in a row that are not empty, and how to use a macro to quickly select the blank rows.

Here are the links mentioned in the video:
How to turn off Table formulas (structured references):

[uc]

Excellent video. Thank you for teaching us another useful task in Excel too !

[alfredoespinozapelayo]

Thank you man, very helpful, see you in the macro course!

[brucemalek]

Thanks, I just found your page and i like the how this is all setup, great work

[janezklun]

Very useful macro, thank you for sharing

[RS-iorp]

Your videos are well sorted, neat and straight to the point where it's easy to understand, I am a pro nurse transitioning to data analyst and your video help me very well. Thanks man

[gopinath]

Hi john, I am becomes a huge fan of your excel videos.Almost I completed all videos of yours

[Vanisha]

Thank you so much for the video....much appreciated.

[qwantez]

Dude, you are freaking awesome. Thank you sir.

[AnalyticsInDetails]

One of a time saving macro, Sir your explanation and efforts are appreciated.

[atysillia]

Thank You Very Much!!! You just save my world and save me so much time. I usually did manually most of the time and just today I remember to google how to do it in more efficient way and I found you. THANK YOU!!

[apprendredavantage]

Thanks lot for the shared lessons learned and its helpfully

[mahmoodhassan]

It's really awesome!! It helps me to easing my work, thanks.

Hi Jon, Your videos are of great help.Another function that I use is filter the blank rows then press F5, select visible cells only and then hit delete. I hope this works too.

[aguerojg]

Thank you very much Jon, the tips are great and save much time!