Find and Delete Blank Rows in Excel

Find and Delete Blank Rows in Excel



Find and Delete Blank Rows in Excel in one time . You can find all blank rows and delete them at once in excel ! I used the 2 features of excel to delete the blank rows in excel.

How to find and delete all blank rows and delete them

1 - Use Counta formula to identify blank rows

2 - Apply filter to get all blank rows together

3 - Delete all blank rows !

 



To watch more videos and download the files visit http://www.myelesson.org

To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788

Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy