How To Delete Blank Rows In Excel?

Select the worksheet range (or click the top-left cell of the data)

Go to **Home** → **Find & Select** → **Go To Special**

Select **Blanks** → click **OK**

Right-click any selected blank cell → choose **Delete…**

Select **Delete Entire Row** → click **OK**

(Alternative) Select the data range

Go to **Data** → **Filter**

Click the filter dropdown for any column

Uncheck **(Blanks)** → click **OK**

Select the visible (non-blank) rows, then delete the remaining visible blank rows

Go to **Data** → **Filter** to turn filtering off

(Alternative) Use a helper column:

Add a column (e.g., **Delete?**)

In the helper column, enter: `=COUNTA(A2:Z2)=0` (adjust range to your data)

Copy the formula down

Filter the helper column to show **TRUE**

Delete the filtered rows

Remove the helper column

Suggested for You

Trending Today