Smart Excel ==> Delete Blank Rows in Excel

Smart Excel ==> Delete Blank Rows in Excel

Below example make you learn 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

Share this post

Post Comment

17 + 5 =