I have searched for this information for a long time and gave up. I then came across your video last week. Your instructions were easy and fast to implement! Now, I am more efficient in completing my deliverables. Huge thanks! I sincerely appreciate the content!
@S.Aboroa
Жыл бұрын
same for me. i have over 12k empty cells to delet without missing the formatting. thanks to him
@raginiyadav5791
5 ай бұрын
This is what I was looking for....I have an Excel of some 70pages where I have to remove empty cells...doing it manually would take a lot of time....this made my work easy thank you😊
@user-zp3dq9or7l
Жыл бұрын
i find less videos regarding this excel problem in you tube. Found this. Literally saved my time. Ur a genius. subscribed ur channel
@monusingh-jz6er
5 ай бұрын
Lovely trick. Thank you ❤
@binaypatel7665
Жыл бұрын
Perfect thank you. I had this idea but didn’t know what the formula was to do this over a large amount of data I will give it a go. Much appreciated.
@bala8217
Жыл бұрын
Glad it helped!
@hiralpayak1272
17 күн бұрын
Nice video..thanks
@vedicastrologybyrani1197
Жыл бұрын
Unlike others, u did not waste time by the baiting your stuff instead, you were to the point thank you Great job!!!
@bala8217
Жыл бұрын
Glad it was helpful!
@kali6678
4 ай бұрын
😂😂.. For removing blank rows.. just select data then click on DATA > click Remove Duplicate > click Ok Done.. Just as simple as delete..😂😂😂😂😂
@vedicastrologybyrani1197
4 ай бұрын
@@kali6678 thanks for your reply. But my message was about eight months ago. 🤣 I needed the reply then Which I found from other channel
@joshwa3911
2 ай бұрын
Thank you for uploading these video
@teddyeragbai8164
8 ай бұрын
Thanks for this. Saved me alot
@bikeshshahi179
Жыл бұрын
Thank you. just found a video that i needed
@fix612
15 күн бұрын
Thank you sir
@Beautymovesindia
Жыл бұрын
Sir WoW , you have done easy my work. thanks a lots.
@godlunity1149
9 ай бұрын
Daayymnn. very useful simple but time saver
@rajasekar006
9 ай бұрын
I search for this exact issue.. Thank u so much
@ShineMicheal
5 ай бұрын
wonderful trick. Thank you so much
@SUMITBARIA
Жыл бұрын
Nice technique sir Thankyou so much it saved my lot of time n efforts
@bala8217
Жыл бұрын
Most welcome
@OnlineGuru001
Жыл бұрын
So simple.... Thanks 🙏
@pancux670
7 ай бұрын
I was using "isblank" but it was returning wrong results as there seems some data in blank looking cells. Then your suggestion for "Counta" did the magic. Thanks
@chuy30able
Жыл бұрын
YOU ARE A MASTER OF THE UNIVERSE, YOU GOT ME OUT OF MY SH**IT, THANK YOU SO MUCH, HUGS FROM MEXICO ... F**CK THE MACROS
@bala8217
Жыл бұрын
Thank you
@ishansharma3741
Жыл бұрын
Saved my life
@ademuyiwarichard
Жыл бұрын
thanks you saved me.
@ethanbourne8798
6 ай бұрын
Thank you Sir !
@prasannaravijr1420
Жыл бұрын
what keys does he press from 1.05 to 1.10
@dineshanblazahan9843
Жыл бұрын
Perfect 👍
@shoppersdream
6 ай бұрын
Nice, thanks!
@narayanavoruganti2154
Жыл бұрын
Thanks brother.
@marufhossain4875
7 ай бұрын
thanks
@mansaj594
6 ай бұрын
How did he select the entire dataset after applying the formula on the first row? When I try to do the same it’s stopping near the next black row. So not able to apply the formula to the entire dataset. Please help! Thanks so much!!
@ArvindYadav-cr9nv
Жыл бұрын
Thank you sir 🙏
@shreyascnayak9910
4 ай бұрын
Thank you, but it's still not working, as it's not allowing me to delete the rows when we have applied a filter, just like you selected the 0 ones and deselected the rest, any other ways?
@dhaneshamirpuri7059
2 жыл бұрын
genius!!
@Kizaru11
4 ай бұрын
Small Doubt If we delete the blanks in between. Doesn't it delete the data? Pls Confirm
@samiawad504
Ай бұрын
Need the same solution but by VBA
@Sathishu001
10 ай бұрын
Thanks a lot
@greysymphonyearth
2 ай бұрын
How do you get it to count?
@anshilchahar2002
7 ай бұрын
hii sir how i can chat with you ? i want a automated format regarding real estate accounts management ? hope you will help me 🙏
Пікірлер: 51