Microsoft Excel 2007 with Example

5 Find & Select

5.2 Find & Select :Delete Blank Rows

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

1. On the Home tab, click Find & Select, Go To Special...

Click Go To Special

2. Select Blanks and click OK.

Select Blanks

Excel selects the blank cells.

Delete Blank Rows in Excel

3. On the Home tab, click Delete, Delete Sheet Rows

Delete Sheet Rows


Delete Blank Rows Result