HOW TO DELETE BLANK ROWS WITHOUT LOSING DATA [THE RIGHT WAY]

[@Spreadsheeto]

👋 3 ways I can help you!
1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com
2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/
3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/

[@ojinwayoonyeze3864]

I was actually running a course on coursera when I decided to clarify this deleting of empty spaces, and boom, your method was fun filled and seamless. Thank you very much.

[@valk8466]

no nonsense long preamble, to the point clear, easy peasy! thank you!

[@spppl26]

Thank you. All other videos did not help… this one did!!! Great job!!!!

[@YsmaelCastillo-k6p]

I just found you and you save me with tons of hours of work.

[@jcevents7662]

Dude, the best explanation that i have found.

[@gloriawaritimi5286]

Love love your channel. Straight to the point. I'm telling all my guys to definitely plug in here for tips.

[@Spreadsheeto]

Thank you so much, Gloria! You rock🙌

[@rashelsikder6023]

it's really help for me just now I'm straggling to remove huge row from a big spreadsheet, you save my 2 hours, thank dear for your good tutorial.

[@khairunnidahajiabdullah8030]

love how you demo us thank you very much sir!

[@AmitSingh-he3uu]

Thanks for the video and explaining the difference between 2 methods

[@Spreadsheeto]

You are very welcome! :)

[@sovithonhin6831]

Nicely explain! It helps me speed thing up. Thanks!

[@tejasjoshi6728]

This is super helpful. Thank you so much!

[@lisaatkinson1381]

Thank you. The one that actually works

[@justinb3355]

Thank you for saving my life, genius!!!

[@adammajid8547]

Actually worked perfectly, thanks!

[@icecubez3]

Saved me hours of time! Thank you for the share kind sir

[@Spreadsheeto]

Great to hear! Thanks for watching :)

[@AparnaJain1]

Great video! Very professionally done. Good structure too.

[@Spreadsheeto]

Thank you, Aparna!

[@Learneditfromyou]

Excellent step by step.

[@Spreadsheeto]

Thank you!

[@davepeeters6518]

Worked GREAT. Thanks

[@mofazzalchowdhury9874]

your tutorial is really helpful and wonderful innovative.

[@Spreadsheeto]

Thank you, Mofazzal!

[@rishi6502]

Can you tell me how this is done for sheets that are online. The f5 methodd doest show up in the online sheets. Its just reloading the tab.

[@Nakul_Sarasan]

Excellent thanks for that!!! also, request you to add all the excel training videos under one playlist in your channel that would be easy to access.

[@Spreadsheeto]

Sure, here you go! th-cam.com/video/FYnjsxpl6oY/w-d-xo.html

[@aashiqahamed666]

Thanks for the video.

[@donovanraj4646]

Thank you. Really helps.

[@nabkawe]

very helpful thank you

[@Spreadsheeto]

You're welcome!

[@amarshrestha3815]

Thank you so much ❤❤

[@isiomanwosu5222]

It’s now working for mine😭. If I find a column that has blank and I start checking each column to deselect all and leave only blank, I end up not finding any blank and I can’t click ok. Please what can I do?

[@segsb7085]

Thank you!

[@judithabreucorcho4510]

Y O U A R E T H E B E S T !!! THANK YOUUUUUU‼

[@jonathancortez5179]

thank You and blessings

[@riyascp4162]

IT IS HELPFUL

[@therencevaldez2841]

IS there a shortcut to delete rows from 101 row to last rows 1,048,576? Thanks

[@lgarvey2001]

what if I have 500 rows and the rest are blank? can I use the first method without having to highlight the blanks and scrolling then deleting?

[@shoppersdream]

Nice, thanks!

[@bloodygreatgirl]

Thank you

[@Silentnight2580]

How ro recover it please

[@kentmorstain4971]

Doesn’t the data to the right of the blank cells get deleted, or do the cells below get shifted up when you select delete blank cells?

[@Spreadsheeto]

Exactly! That's why you need to use the filter method so you only delete rows that have no data at all.

[@rediryou]

I wished this works but it doesn't and I am wondering if it's because my cells are not blank but rather null. I am also working with a file that has 30,000 rows so maybe it's too big.

[@Saad.PS2009]

Thanks

[@raesalim9341]

When I go to Data, I cannot select Filter?

[@maheshsanghani6380]

GOOD VIDEO .

[@katiaairymadridloza9312]

Didn’t work for me, the delete sheet rows option is grayed out

[@divyasharma3812]

Good video

[@Spreadsheeto]

Thanks!

[@Yeast1337]

thanks bro

[@carlosdg2319]

Thank you 🎉 straight forward and definitely learned something new

[@H0LDENSUX]

I was expecting a link to a macro I could copy and paste into VBA Excel to save time and money.

[@Spreadsheeto]

That's a great suggestion for a future video. Thanks :)

[@rachaelplassmeyer2720]

Did not work for me be cause I am extracting the data from an extracted view of a pdf :(

[@ch00226855]

what if there are hundreds of columns?

[@saifrehman7124]

Great

[@amarfateen]

Extremely arduous way of doing things! This is such a time taking process; there are far more speedy and smarter ways of doing what you are trying to do here. I am leaving a link for your reference that makes things easier.
th-cam.com/video/aBuJiY_EpIM/w-d-xo.html

[@Mal-xl8jh]

Omggggg I just one a video when it is not blank space. Ahhhh

[@Sunlo_Studio_Hindi_Stories]

Tysm bro