A quick way to delete a large number of blank rows in a table in Excel

1. Start Excel and open the worksheet, select a column in the worksheet, and on the Data tab, in the Sort and filter group, click the Filter button, as shown in Figure 1.

Figure 1 Click the Filter button

2, click the AutoFilter down Triangle button that appears to the right of the first cell in the column, uncheck the (Select All) check box in the Open list, tick the (blank) check box, and click OK, as shown in Figure 2.

Figure 2 tick the (blank) check box

3, the worksheet will display only blank lines, select the blank line to delete, on the Start tab, in the Cells group, click the Delete button to delete the selected blank row, as shown in Figure 3.

Figure 3 Deleting a blank line

4, on the Data tab, in the sorting and filtering group, click the Filter button again to cancel the AutoFilter state, when the worksheet will reappear with the data, and the blank row has been deleted, as shown in Figure 4.

Figure 4 Click the Filter button to cancel the AutoFilter status