👋 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/
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.
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.
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. ua-cam.com/video/aBuJiY_EpIM/v-deo.html
👋 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/
no nonsense long preamble, to the point clear, easy peasy! thank you!
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.
I just found you and you save me with tons of hours of work.
Thank you. All other videos did not help… this one did!!! Great job!!!!
Dude, the best explanation that i have found.
Nicely explain! It helps me speed thing up. Thanks!
Love love your channel. Straight to the point. I'm telling all my guys to definitely plug in here for tips.
Thank you so much, Gloria! You rock🙌
love how you demo us thank you very much sir!
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.
Actually worked perfectly, thanks!
Thanks for the video and explaining the difference between 2 methods
You are very welcome! :)
Worked GREAT. Thanks
This is super helpful. Thank you so much!
Saved me hours of time! Thank you for the share kind sir
Great to hear! Thanks for watching :)
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.
Sure, here you go! ua-cam.com/video/FYnjsxpl6oY/v-deo.html
Thanks for the video.
Excellent step by step.
Thank you!
Great video! Very professionally done. Good structure too.
Thank you, Aparna!
Thank you. Really helps.
your tutorial is really helpful and wonderful innovative.
Thank you, Mofazzal!
thank You and blessings
Y O U A R E T H E B E S T !!! THANK YOUUUUUU‼
Thank you!
very helpful thank you
You're welcome!
IT IS HELPFUL
Thank you so much ❤❤
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.
Nice, thanks!
IS there a shortcut to delete rows from 101 row to last rows 1,048,576? Thanks
Thank you
Thank you 🎉 straight forward and definitely learned something new
Thanks
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?
Tysm bro
GOOD VIDEO .
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?
Exactly! That's why you need to use the filter method so you only delete rows that have no data at all.
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.
Good video
Thanks!
How ro recover it please
Didn’t work for me, the delete sheet rows option is grayed out
When I go to Data, I cannot select Filter?
I was expecting a link to a macro I could copy and paste into VBA Excel to save time and money.
That's a great suggestion for a future video. Thanks :)
Did not work for me be cause I am extracting the data from an extracted view of a pdf :(
what if there are hundreds of columns?
Great
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.
ua-cam.com/video/aBuJiY_EpIM/v-deo.html
Omggggg I just one a video when it is not blank space. Ahhhh
thanks bro