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.

2. Select "Go to Special." 4. Excel will then highlight all of the blank cells. Before you delete the blank cells, ensure that only the cells that you want to remove are highlighted. If you just ...