How to delete all blank rows in Excel in 3 seconds

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.

[@AlexM-ym7kd]

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

[@amjadsaleem1270]

Thank you

[@MsMekia-dl3el]

Thank you

[@user-jv2sd3gj8x]

Maaaaan, I hope they just get to the point. We ain't 5 yo's. Thanks!

[@janellerobinson696]

I was going to post the same thing. THANK YOU!

[@david3108]

Thanks for getting us straight to the point! I got 2:56 of my life back!

[@BreilaMorgan]

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

[@jonathanfriz4410]

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.

[@Neil532]

This is an excellent 7 min video.
Worth the watch!

[@ddpro288]

You saved my 5 mins when i was in a hurry thanks

[@raviranjanprakash1705]

Thank You Sir, you helped in saving time and removing extra work. Thanks from the bottom of my heart.

[@laurencerogers4467]

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.

[@darkspace3316]

Starts from 4:58

[@archangels4you593]

Managed to save ton of time... Thank you so much for this wonderful tip !!!!

[@janithapanicker5338]

Thank you. That was so clear!

[@nevillecooper5437]

Wonderful fix! Thank you for being so clear and making this so simple!!!

[@TheTechTrain]

Thank you, you're very welcome!

[@gambu4810]

@@TheTechTrain 🤣🤣🤣🤣🤣

[@zacharymasiewicz1175]

Thank you for this! Saved me hours.

[@MsLoveCentral]

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

[@raccoon874]

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

[@graemed-g522]

That is exactly what I discovered...

[@raychelleinjete4024]

Very useful! Thank you.. Looking forward to more videos.....I really needed it

[@JunkAccount-ig8st]

You just saved me hours of work!!! Thank you!!!

[@carlospena8846]

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

[@joshuamanampiu6489]

Thank you. This saved me so much time.

[@excel3373]

Thank you very much for your effort and time to make us understand this concept.

[@kanchanawiang7520]

Thank you so much for your video. Exactly what I looked for.

[@Santa_Barbara_Luxury_Estates]

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

[@TheTechTrain]

Please remember that not all of my viewers are as proficient, including many of my school students, and they often comment how much they appreciate the explanation of the problem, so that they understand the solution rather than simply have the quick fix without context.

[@Suleimanmoallim]

Alright, the best way, it solved my problem really thanks sir

[@davidrobins4025]

Simple clear explanation of how to accomplish this task. Excellent. Thanks

[@MrLbott]

I consider myself tech savvy... you've just put me to shame.... 😂😂 quality mate... top drawer!!

[@dzxy314]

This deletes all rows with one or more blank cell, which is not necessarily a blank row.

[@josephbadams1]

Damn.

[@user-jv2sd3gj8x]

That's my dilemma too.

[@tracycass7387]

me too

[@AhmedHasan-fp9hl]

U can select only those column from top in which u have text and then apply this method

[@graemed-g522]

Me too...

[@NitinPatil-bu7hj]

delete all blanks, saved me days of work. good job!

[@nethrar9178]

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 ...

[@TheTechTrain]

Thank you, I'm so glad you liked it.

[@blackhand2850]

@@TheTechTrain if my F5 not working thn how to open that option

[@JohnSnow32]

You deserve a lot of love from anyone

[@mugdhanaik7241]

Thanks a ton for this amazingly useful video

[@kapiljain3524]

Thank You so much mate for this wonderful trick...

[@simonaaland7076]

You just saved me an exteme amount of time. Thank you so much

[@TheTechTrain]

I'm so glad you found it useful!

[@madebysaad]

Thank your sir. 😃 Respect from India👍👍👍

[@abdussakurtalukder9714]

Its incredible! I loved it

[@monadm5697]

Hello, I have a table with 6 colums but with 21420 rows , couldnt past it into Excel, do you have a method for doing that? Thanks ..

[@TheTechTrain]

What format is the table currently in?

[@ericodonoghue]

Nice tutorial, very useful. Thank you.

[@TheTechTrain]

Very glad you liked it

[@Craig-MItchell]

Fabulous, thanks a big number 👏🏻

[@nurettinuysal8392]

Thanks it is very quick and clear.

[@felyndolloso3861]

Very simple instruction. very helpful. thank you so much sir :)

[@askesqkuyea2184]

Thanks for this tutorial video. It was very useful.

[@massagewalaofficial]

Truly bless u. it saved lot of time

[@hendricklin6438]

You saved me a day. Thank you so much!

[@TheTechTrain]

You're welcome!

[@Irina_M1989]

Thank you very much for the useful tip!

[@teresagoncalves4134]

Thank you so much. Very well explaned. Simple and perfect.

[@TheTechTrain]

Glad it was helpful!

[@gelliesibanda8803]

Wonderful. Very useful information. Much appreciated

[@TheTechTrain]

Glad you enjoyed it!

[@Februarybaby68]

Thank you so much for this! 😊

[@Jasminfromjersey]

This helped me in the nick of time today. 🎉🎉 😊 thank you!!

[@kenshin-ali3368]

Excellent. wow content. Solve problem instantly. Many thanks

[@VarunKumarSahu]

So useful tip, thank you so much

[@RandomChatwithIqra]

Wow Amazing trick in seconds. Thank you so much

[@mohammadjunaidghauri911]

Can you explain how can I remove blank rows in case I have a blank column that does not need to be eliminated?

[@hifzaafaq8944]

Thanks! It was really helpful.

[@gunshipguy]

Now I know how my kids feel when they want a quick answer and I feel a need to explain to them how the universe came into being before getting to their specific question.

[@PraKashVaratha7223]

Thanks for guidance to delete row.

[@katielee3269]

thanks for sharing the tips to delete all blank rows.

[@TheTechTrain]

You're very welcome Katie, I'm glad you found it useful.

[@rudygomez9784]

I like the video introduction... the animation... looks great!

[@TheTechTrain]

Thank you, I'm glad you like it.

[@roclobster1211]

Bless you, 3 sec fix in 5 minutes :)

[@AJsVIEW]

Thanks, you saved my day!

[@raychelleinjete4024]

Ok. I just tried your formula and it worked! I feel really pleased with myself... I've subscribed and will share widely...

[@mikehammer6130]

I had 35,000 rows and so many empty ones thank you so much !!!

[@julianatoluakinbami5080]

Thank you very much you saved the day. I had 602 numbers to work with

[@Zadythomas]

Thank you!

[@Babasaheb031]

Thank you for the insightful.

[@andrescs91]

worked like a charm!

[@Amit67014]

Thank you so much tech train, it's so helpful

[@theking20102009]

thank you this is really helpful !

[@idor.doanis]

thanks very much ! super easy ty teach !

[@beyondlimitsproductions1468]

You have a gift my friend .

[@sahilkhan2470]

i gave tumbs up before i go. now i am going. thanks.

[@johnxenofontos1058]

Thanks a lot removed 2000 blank rows :)

[@77Yael63]

Wonderful!! Helped me greatly!

[@TheTechTrain]

Glad it helped!

[@Eselkay1989]

Thanks dude. It saved me hours. As you've mentioned, it's was indeed a huge time saver! Keep helping .....

[@BilalKhan-ol1lt]

Thank you Man, so easy now!!

[@berghoutcful]

When I do this is Excel 2016, it defaults to finding blank columns, not rows. Any solution for this? Thanks for the video!

[@rockyrocky3274]

It was really good learning in no time

[@parankrishna8216]

Thank you for the instant help😀

[@ashleymarie7452]

Excellent. Thank you!

[@reggie9550]

You saved my time..Thank you for this video . so clearly explained. Well done and Thank you again.

[@dynamiccontractsconsultant4171]

Thank you for the information.

[@suetaoufiq2291]

Very helpful!! Thank you!!

[@arrianranger5800]

Thank you first time ab excel tutorial worked for me.

[@TheTechTrain]

Glad it helped!

[@silverspoontraveller1075]

You are a lifesaver👍🏻

[@Navasudeen]

Thanks for information

[@sonasingh131]

thanks so much, love it!

[@TheTechTrain]

Glad you like it!

[@Perspectivesbyme]

Amazing thank you!!

[@dhanrajhs8862]

Thank you so much to show this tricks to us

[@MaryZappamb4chrst]

Your amazing, thank you so much!!!!

[@konli]

This is Great !!
Wanted a Macro that would delete all blank spaces rows and columns
the rest of the videos were to complex and did not work
recorded it on the developer (Macro)
it work fine !!!!!!
Thank You

[@qu_entin]

Thank you, helped me big time

[@rajfencings4993]

Thanks a ton , you saved my million dollar time....

[@TheTechTrain]

Glad to hear that

[@shivaprasad5239]

Thank you, that helped me alot 👍

[@TheTechTrain]

I'm so glad!

[@nandkishoreb8696]

A big big big thank you.

[@sagsmg123]

Does it work if in between rows few cells are merged?

[@zevschnitzer5101]

wonderful example , i have been looking for this for a while and i am very lucky to find your demonstration.
a question that i have , suppose these rows had text in them and they have to be deleted (repetition) but different text
will this example also work?
thanks
Zev

[@Germaneasytech]

Keep it simple and sweet

[@claudiamichielini933]

Well explained and SUPER HELPFUL ! THANK YOU ❤️

[@dannyboy9784]

Thanks for the great tip

[@bhavapritaapara9274]

It's very useful. thank you

[@jonxina983]

Thank you my man ❤️

[@mitch1668]

Settings > Playback Speed > 2
thank you for this video!

[@HappyheartbyNida]

Thanks alot for solving my problem. I subscribed your channel after watching this video.

[@TheTechTrain]

Thank you so much, I'm very glad you liked it

[@prasannasimhatr]

Thank you so much, you made my day!

[@AZ96949298]

thanks for saving my mental health