How to delete all blank rows in Excel in 3 seconds

[@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!

[@carlospena8846]

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

[@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

[@MsLoveCentral]

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

[@JohnSnow32]

You deserve a lot of love from anyone

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

[@madebysaad]

Thank your sir. 😃 Respect from India👍👍👍

[@teresagoncalves4134]

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

[@TheTechTrain]

Glad it was helpful!

[@thramart7805]

Thank you So Much Brother ...

[@TheTechTrain]

Glad to help!

[@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

[@raviranjanprakash1705]

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

[@nurettinuysal8392]

Thanks it is very quick and clear.

[@arrianranger5800]

Thank you first time ab excel tutorial worked for me.

[@TheTechTrain]

Glad it helped!

[@raychelleinjete4024]

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

[@mitch1668]

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

[@excel3373]

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

[@Jasminfromjersey]

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

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

[@darkspace3316]

Starts from 4:58

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

[@massagewalaofficial]

Truly bless u. it saved lot of time

[@johnxenofontos1058]

Thanks a lot removed 2000 blank rows :)

[@NitinPatil-bu7hj]

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

[@kenshin-ali3368]

Excellent. wow content. Solve problem instantly. Many thanks

[@rajfencings4993]

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

[@TheTechTrain]

Glad to hear that

[@julianatoluakinbami5080]

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

[@nevillecooper5437]

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

[@TheTechTrain]

Thank you, you're very welcome!

[@gambu4810]

@@TheTechTrain 🤣🤣🤣🤣🤣

[@sahilkhan2470]

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

[@MrLbott]

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

[@rudygomez9784]

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

[@TheTechTrain]

Thank you, I'm glad you like it.

[@kanchanawiang7520]

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

[@beyondlimitsproductions1468]

You have a gift my friend .

[@bhavapritaapara9274]

It's very useful. thank you

[@gelliesibanda8803]

Wonderful. Very useful information. Much appreciated

[@TheTechTrain]

Glad you enjoyed it!

[@mikehammer6130]

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

[@aprilstefanik1638]

Thank you so much!!! This worked for me :)

[@KhaledAlarofi]

Thank you sir, that was a big help

[@TheTechTrain]

Glad it helped

[@Babasaheb031]

Thank you for the insightful.

[@Irina_M1989]

Thank you very much for the useful tip!

[@AZ96949298]

thanks for saving my mental health

[@RandomChatwithIqra]

Wow Amazing trick in seconds. Thank you so much

[@simonaaland7076]

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

[@TheTechTrain]

I'm so glad you found it useful!

[@AnandGautam9901]

That's very simple and Quick

[@mugdhanaik7241]

Thanks a ton for this amazingly useful video

[@askesqkuyea2184]

Thanks for this tutorial video. It was very useful.

[@davidrobins4025]

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

[@prasannasimhatr]

Thank you so much, you made my day!

[@rohaanbaby1905]

Very nicely explained

[@Amit67014]

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

[@prateikdixit6985]

Nothing much to comment so will just Thank you for the help!
Thanks a lot

[@hifzaafaq8944]

Thanks! It was really helpful.

[@dynamiccontractsconsultant4171]

Thank you for the information.

[@TheMrRomely]

ALT+E+D to delete faster and without the mouse

[@salmanalvi9552]

Thanks

[@ram.nm7777]

This is not what actually the video is for oly to remove the blank for complete details

[@Joesusas]

thanks man. you're a lifesaver.

[@Dhiyaneshwar_Vlogger_12]

Excellent buddy! 🎉

[@adina3]

Or CTRL -

[@VarunKumarSahu]

So useful tip, thank you so much

[@AJsVIEW]

Thanks, you saved my day!

[@parankrishna8216]

Thank you for the instant help😀

[@trafikoinc5494]

already did it manual way with 792 rows and then i realized i got youtube. THANK YOU IN ADVANCE

[@katielee3269]

thanks for sharing the tips to delete all blank rows.

[@TheTechTrain]

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

[@silverspoontraveller1075]

You are a lifesaver👍🏻

[@dannyboy9784]

Thanks for the great tip

[@dnesdnddd2202]

Thanks so much saved me a few hours😂👍

[@binovivo9396]

Very interesting video... 🥰

[@zacharymasiewicz1175]

Thank you for this! Saved me hours.

[@roclobster1211]

Bless you, 3 sec fix in 5 minutes :)

[@hendricklin6438]

You saved me a day. Thank you so much!

[@TheTechTrain]

You're welcome!

[@archangels4you593]

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

[@qu_entin]

Thank you, helped me big time

[@Suleimanmoallim]

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

[@ashleymarie7452]

Excellent. Thank you!

[@geiobal7902]

Very helpful👍👍

[@TheTechTrain]

Glad to hear it!

[@evelynbartels3443]

Thank you its really works

[@raychelleinjete4024]

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

[@ericodonoghue]

Nice tutorial, very useful. Thank you.

[@TheTechTrain]

Very glad you liked it

[@ismailhossain9284]

thank bro .vry helpful video

[@nandkishoreb8696]

A big big big thank you.

[@abdussemiiabuali3585]

Merci beaucoup.
Time saver...

[@Germaneasytech]

Keep it simple and sweet

[@jonxina983]

Thank you my man ❤️

[@arunapal08]

Very Helpful

[@moulimallina7501]

Thank you so much sir really helpful

[@TheTechTrain]

I'm so glad. You're very welcome.

[@lawenforcer11]

For most of the excel users video starts at 02:30

[@katoloniable]

😂👍🏾

[@berozgarengineer2685]

Thanks a lot brother..it helps a lot

[@research135]

that was nice. thank you!

[@idor.doanis]

thanks very much ! super easy ty teach !

[@dhanrajhs8862]

Thank you so much to show this tricks to us

[@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

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

[@omkarsawant5193]

That was very helpful thanks 😌

[@77Yael63]

Wonderful!! Helped me greatly!

[@TheTechTrain]

Glad it helped!

[@baraaalsakkal1349]

thank you that was helpful

[@deepikams9002]

Thanks for your help

[@sonasingh131]

thanks so much, love it!

[@TheTechTrain]

Glad you like it!

[@deus451]

waoooooo!!!! i Like it, it has saved my Job

[@jitendrakewat5771]

Thanks a lot brother🙏🙏👍

[@TheTechTrain]

You're very welcome

[@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

[@joshuamanampiu6489]

Thank you. This saved me so much time.

[@JunkAccount-ig8st]

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

[@rockyrocky3274]

It was really good learning in no time

[@surensalgado9175]

Very useful 👍✔