MOBILE SE DELETE KARE ALL EMPTY BLANKS ROWS TOGETHER THROUGH MOBILE APP IN EXCEL TO DO SMART WAY

3 years ago
24

FRIENDS WELCOME TO MY CHANNEL TODAY I WILL TELL YOU THAT HOW YOU CAN DELETE YOUR ALL LANKS ROWS THROUGH WITH THE HELP OF YOUR MOBILE APP OPEN YOUR EXCEL SHEET WHERE YOU HAVE KEPT YOUR DOCUMENT CHECK ALL BLANKS ROWS .PUT (COUNTA FORMULA )THEN SELECT COMPLETE ONE ROW AT SIDE OF FORMULA THEN ADD FILTER ON IT THEN DRAG ALL DOCUMENT FILE WITH THE HELP OF (FILL OPTION) UP TO END AND ENTER ALL YOUR DOCUMENT WILL COUNT WILL SHOWN THEN GO AGAIN SELECT FILLTER ,FROM THERE SELECT NUMBER OF FILLTER THEN SELECT EQUALIN SEARCH BAR SELECT ZERO (0) AND ENTER ALL YOUR ZRRO (0) WILL SHOWN THEN SELECT ALL ZERO (0) DON'T SELECT FILLTER SELECT ALL AND DELETE IT NOW SELECT FILLTER FROM FILLTER OPTION AND DELETE FILLTER AND YOUR ARE DONE.

Loading 1 comment...