Delete Blank Rows

 

This example teaches you how to delete blank rows or rows that contain blank cells.

1. On the Home tab, in the Editing group, click Find & Select.

Click Find & Select

2. Click Go To Special.

Click Go To Special

3. Select Blanks and click OK.

Select Blanks

Excel selects the blank cells.

Delete Blank Rows in Excel

4. On the Home tab, in the Cells group, click Delete.

Click Delete

5. Click Delete Sheet Rows.

Delete Sheet Rows

Result:

Delete Blank Rows Result

Do you like this free website? Please follow us on Google+