How to delete all blank rows in Excel in 3 seconds

789,799

8,780 0

Published 2015-06-25

If you have multiple blank rows in a spreadsheet it can be very time-consuming to try to delete them either individually, or selecting them and then deleting them. In this quick tutorial I'll show you a very easy way to delete every blank row in a table or entire spreadsheet in under three seconds flat.

All Comments (21)

@AlexM-ym7kd 4 years ago

Thank you for the informative video. Here is the 10 second answer for those who just want to get to the point 2:56
@BreilaMorgan 4 years ago

Bless your soul. You just saved me three hours of right clicking. Amazing. Very clear. Have a great day!
@jonathanfriz4410 4 years ago

This video is great for the first time user of Excel. If you are not a first time user the steps are: Press F5 (Go to) select Special then Select box Blanks. Then in File select Delete and the option Delete Sheet Rows. Minute 5:07 from the video.
@Santa_Barbara_Luxury_Estates 5 years ago

Far too much explanation and wasting of your breath. Just get to the point. Boom, Boom, Boom and DONE! Thank you!
@laurencerogers4467 2 years ago

Thanks for the tip it was a great help. The actions performed is 6 seconds but the explanation is nearly 6 minutes long. Never the less great video.
@carlospena8846 1 year ago

Thanks man, you´ve saved me lots of time! appreciate it, 7 years later this came handy for me :) thanks
@raccoon874 3 years ago

this works ONLY IF ALL THE ROW IS EMPTY - if you have some rows that have random empty cells, it picks them as well
@JohnSnow32 2 years ago

You deserve a lot of love from anyone
@MsLoveCentral 3 years ago

Oh my god, I needed this and after watching your video I yelled out in happiness. Thank you very much
@madebysaad 2 years ago

Thank your sir. 😃 Respect from India👍👍👍
@nethrar9178 3 years ago

That's true..that was very simple method and I had to spend hours before watching this video. 😭😭 thank you so much sir..Also I like the way you reiterate /summarise at the end ...
@teresagoncalves4134 9 months ago

Thank you so much. Very well explaned. Simple and perfect.
@thramart7805 1 year ago

Thank you So Much Brother ...
@nurettinuysal8392 1 year ago

Thanks it is very quick and clear.
@dzxy314 7 years ago

This deletes all rows with one or more blank cell, which is not necessarily a blank row.
@TheMrRomely 3 years ago

ALT+E+D to delete faster and without the mouse
@massagewalaofficial 1 year ago

Truly bless u. it saved lot of time
@arrianranger5800 3 years ago

Thank you first time ab excel tutorial worked for me.
@johnxenofontos1058 2 years ago

Thanks a lot removed 2000 blank rows :)
@kenshin-ali3368 1 year ago

Excellent. wow content. Solve problem instantly. Many thanks