How to use filter to delete empty rows in Excel

Take the following table as an example. Select the table and select [Filter] in the data tab above.

Select [Blank] in the filter drop-down menu and click OK.

The empty rows are filtered out and marked with a blue row number. We can right-click to delete the row.

Finally return to filtering and the blank rows will be deleted without affecting the arrangement of the data.

The above is the detailed content of How to use filter to delete empty rows in Excel. For more information, please follow other related articles on the PHP Chinese website!