Delete empty blank rows

Delete empty blank rows

Saturday, February 9, 2019

2:05 PM

About:

How to delete any empty blank rows in Excel

Steps:

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

From <https://www.excel-easy.com/examples/delete-blank-rows.html>