MS Excel: Deleting complete blank rows without deleting blank cells in the filled row 

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!

I messed up my analysis today because of this method..blanks in cell also got del and data got misplaced...a day wasted.. but ultimately thanq for this knowledge..❤

Unlike others, u did not waste time by the baiting your stuff instead, you were to the point thank you Great job!!!

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😊

i find less videos regarding this excel problem in you tube. Found this. Literally saved my time. Ur a genius. subscribed ur channel

Nice video..thanks

Lovely trick. Thank you ❤

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.

Thank you sir

Thank you for uploading these video

Thanks for this. Saved me alot

wonderful trick. Thank you so much

Daayymnn. very useful simple but time saver

Thank you. just found a video that i needed

Sir WoW , you have done easy my work. thanks a lots.

I search for this exact issue.. Thank u so much

How do you get it to count?

Thank you Sir !

what keys does he press from 1.05 to 1.10

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

thanks you saved me.

Saved my life

how did u do 1:00 to 1:15

Need the same solution but by VBA

Nice technique sir Thankyou so much it saved my lot of time n efforts

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

Nice, thanks!

Thanks brother.

So simple.... Thanks 🙏

Small Doubt If we delete the blanks in between. Doesn't it delete the data? Pls Confirm

Thank you sir 🙏

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

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?

Thanks a lot

Perfect 👍

How can we do the same for blank columns

hii sir how i can chat with you ? i want a automated format regarding real estate accounts management ? hope you will help me 🙏

genius!!

Thanks ji

thanks

Thankyou

Ho nhi Raha hai large error de raha h

🙏🙏

Thank you sir

Thank you sir