In this post you will learn how to delete/remove multiple blanks rows by using easy simple method, if you try to delete blank rows one by one it will take lot of time and concentrate, but here I will show you easiest way to delete multiply blank rows at one same time. This method will work all the version of Microsoft Excel like 2003, 2007, 2010, 2013 & 2016. Lets see how to do this.
1. Select your matter including blanks rows and press “F5” than click on “Special” you will get one box, select “Blanks” and “Ok”
2. Now you can see all your blank rows will selected, just hold “Ctrl” and press “-“ (Ctrl -), check on “Entire Row” and hit on “Ok”
Watch video tutorial… Please like, share & subscribe