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

[lydierskil]

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!

[zpdqorl]

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

[raginiyadav]

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😊

[binaypatel]

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.

[vedicastrologybyrani]

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

thank you

Great job!!!

[bikeshshahi]

Thank you. just found a video that i needed

[Beautymovesindia]

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

[godlunity]

Daayymnn. very useful simple but time saver

[rajasekar]

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

[SUMITBARIA]

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

[pancux]

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

[prasannaravijr]

what keys does he press from 1.05 to 1.10

[mansaj]

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

[chuyable]

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

[shreyascnayak]

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?

[amolraut]

How can we do the same for blank columns

[Kizaru]

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

[anshilchahar]

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