Filters are another way to achieve the same aim in Excel. Here is how to use filters to delete blank rows: Click the Filter dropdown arrow in a column of your dataset where some rows are blank.