How to Delete Blank rows in Excel

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…”.


Go to Special

In a new menu window select “Blanks” and press “ok”.

Select Blanks

You can see that blank rows are selected. After that, go to “delete” menu and choose “delete cells”.

Delete cells

In opened delete menu select the delete options and press “ok”. Now the blank rows are deleted.

Select delete options