In this video tutorial we will show you how to delete blank rows in excel.
Open the excel document you want to edit. Select the part of the text where the blank rows are and you want to delete. Now click “Find & Select”, in popup menu choose “Go To Special…”.
In a new menu window select “Blanks” and press “ok”.
You can see that blank rows are selected. After that, go to “delete” menu and choose “delete cells”.
In opened delete menu select the delete options and press “ok”. Now the blank rows are deleted.