How To Remove Blank Rows In Excel?

Select the data range (or the entire worksheet)

Go to the Home tab

Click Find & Select

Click Go To Special

Select Blanks

Click OK

Right-click any selected blank cell

Click Delete…

Choose Delete cells up, or Delete entire row, depending on your layout

Click OK

If needed, repeat for remaining blanks

Alternative: Select the data range

Go to the Data tab

Click Filter

Click the filter drop-down on a key column (e.g., the first column)

Clear (Select All) and then select only non-blank values

Select the visible rows

Right-click and choose Delete Row(s)

Clear the filter after deleting

Suggested for You

Trending Today