👋 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/
@Nakul_Sarasan
3 жыл бұрын
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
3 жыл бұрын
Sure, here you go! kzitem.info/news/bejne/p4-k0KeuqZ5noo4
@jonathancortez5179
12 сағат бұрын
thank You and blessings
@mofazzalchowdhury9874
3 жыл бұрын
your tutorial is really helpful and wonderful innovative.
@Spreadsheeto
3 жыл бұрын
Thank you, Mofazzal!
@donovanraj4646
5 ай бұрын
Thank you. Really helps.
@therencevaldez2841
Ай бұрын
IS there a shortcut to delete rows from 101 row to last rows 1,048,576? Thanks
@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!
@H0LDENSUX
3 жыл бұрын
I was expecting a link to a macro I could copy and paste into VBA Excel to save time and money.
@Spreadsheeto
3 жыл бұрын
That's a great suggestion for a future video. Thanks :)
@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. kzitem.info/news/bejne/wnirsJ2PmHehfII
@adammajid8547
12 күн бұрын
Actually worked perfectly, thanks!
@YsmaelCastillo-k6p
Жыл бұрын
I just found you and you save me with tons of hours of work.
@rashelsikder6023
2 жыл бұрын
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.
@rachaelplassmeyer2720
Жыл бұрын
Did not work for me be cause I am extracting the data from an extracted view of a pdf :(
@AmitSingh-he3uu
3 жыл бұрын
Thanks for the video and explaining the difference between 2 methods
@Spreadsheeto
3 жыл бұрын
You are very welcome! :)
@katiaairymadridloza9312
6 ай бұрын
Didn’t work for me, the delete sheet rows option is grayed out
@sovithonhin6831
7 ай бұрын
Nicely explain! It helps me speed thing up. Thanks!
@ch00226855
Жыл бұрын
what if there are hundreds of columns?
@smpaul26
Жыл бұрын
Thank you. All other videos did not help… this one did!!! Great job!!!!
@davepeeters6518
24 күн бұрын
Worked GREAT. Thanks
@khairunnidahajiabdullah8030
11 ай бұрын
love how you demo us thank you very much sir!
@gloriawaritimi5286
8 ай бұрын
Love love your channel. Straight to the point. I'm telling all my guys to definitely plug in here for tips.
@Spreadsheeto
8 ай бұрын
Thank you so much, Gloria! You rock🙌
@AparnaJain1
3 жыл бұрын
Great video! Very professionally done. Good structure too.
@Spreadsheeto
3 жыл бұрын
Thank you, Aparna!
@jcevents7662
11 ай бұрын
Dude, the best explanation that i have found.
@kentmorstain4971
3 жыл бұрын
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
3 жыл бұрын
Exactly! That's why you need to use the filter method so you only delete rows that have no data at all.
@aashiqahamed666
6 ай бұрын
Thanks for the video.
@Silentnight2580
2 жыл бұрын
How ro recover it please
@tejasjoshi6728
2 жыл бұрын
This is super helpful. Thank you so much!
@rediryou
2 жыл бұрын
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.
@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?
@riyascp4162
3 жыл бұрын
IT IS HELPFUL
@rishi6502
2 жыл бұрын
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.
@judithabreucorcho4510
Ай бұрын
Y O U A R E T H E B E S T !!! THANK YOUUUUUU‼
@icecubez3
3 жыл бұрын
Saved me hours of time! Thank you for the share kind sir
@Spreadsheeto
3 жыл бұрын
Great to hear! Thanks for watching :)
@raesalim9341
2 жыл бұрын
When I go to Data, I cannot select Filter?
@Learneditfromyou
3 жыл бұрын
Excellent step by step.
@Spreadsheeto
3 жыл бұрын
Thank you!
@nabkawe
3 жыл бұрын
very helpful thank you
@Spreadsheeto
3 жыл бұрын
You're welcome!
@bloodygreatgirl
2 жыл бұрын
Thank you
@Mal-xl8jh
3 ай бұрын
Omggggg I just one a video when it is not blank space. Ahhhh
@shoppersdream
7 ай бұрын
Nice, thanks!
@divyasharma3812
3 жыл бұрын
Good video
@Spreadsheeto
3 жыл бұрын
Thanks!
@amarshrestha3815
2 жыл бұрын
Thank you so much ❤❤
@Yeast1337
2 жыл бұрын
thanks bro
@maheshsanghani6380
2 жыл бұрын
GOOD VIDEO .
@segsb7085
2 жыл бұрын
Thank you!
@Saad.PS2009
2 жыл бұрын
Thanks
@saifrehman7124
2 жыл бұрын
Great
@sunlo_studio
Жыл бұрын
Tysm bro
@carlosdg2319
2 ай бұрын
Thank you 🎉 straight forward and definitely learned something new
Пікірлер: 60