How to Delete Rows Or Columns Based On Criteria Or Blanks In Excel

In this tutorial we are going to look at how to delete rows or columns that either have a certain criteria or that are blank.
To download the file and follow along, go to the link on my website at:

Do you need help with a formula or an Excel project?
Including a sample file is always helpful!

You can donate to my channel through any of the following:

PayPal:

Zelle or Venmo:

[monicamccarthy]

Thank you so much. This is exactly what my boss asked me to do today with a sales spreadsheet that had over 8, 000 rows; deleting rows with certain values. You're an awesome teacher! Thanks for keeping your videos plain and simple, no weird background music, easy to understand.

[smarajitpunaykanti]

I had already deleted around 200 rows one by one after frustration brought me to this video. Thanks a ton
From India

[julielaraenelson]

Very helpful. Medical insurance company, dealing with thousands of lines of data. This short, easy explanation was LIFE saving, time saving and brilliant! Thank you!

[LuisSanchezLouieLouie]

Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You, Thank You,

You just saved me soooo much time. and Boy that solution was easy

[NERGYStudios]

Saved my day! Brilliant explanation, short and precise. Thank you!

[chosenacquisitions]

Bless you my friend, I wrestled with this excel sheet for literally hours. This video solved my problem in 2

[ovmepto]

Spreadsheet with over 100, 000 rows and this was the video that came in "clutch!" TY

[veronicas]

This was super duper helpful. Saved me lots of hours. Thank you!

[LuddyPuppy]

Thank you SOOOO much. Every other tutorial I was finding for this required scripting. This is exactly what I needed.

[boss_man]

Bless your Kind heart. You may have just saved my Life😂

[UpExcel]

Excellent shortcut methods Mike. Thanks for the tips 👍

[erichernandez]

Wow. SUCH a time saver thank you so much!!

[memorybwale]

Thanks so much, short and to the point.

[yousaffareed]

Great Man Thank you you save my lots of time

[sazzadabir]

Thanks a lot. You saved my whole day. You are amazing

[Teemikemedia]

Thank you so much. You just saved me from this bulky list on Excel.

[abdulmalik]

Thank you so much, you've saved alot of my time.subscribed and liked

[MrDgroot]

Thank you very helpful! Helped me sort out 7700 contacts today!

[Travdog-ucno]

You are amazing. You saved me hours. Thank you.

[jezhughes]

Excellent, thanks, saved me a tonne of work