How Excel quickly deletes blank rows in a worksheet

How Excel quickly deletes blank rows in a worksheet

1, start Excel 2013 and open the worksheet, there are some blank lines on this worksheet. Select the data range on the worksheet, and on the Start tab, in the Edit group, click the Sort and Filter button to select the Filter option in the Open Drop-down list, as shown in Figure 1.

Figure 1 Selecting the filter option

2. At this point, the right side of the column heading of the datasheet will appear with the Filter down triangle button, click any of the down-triangle buttons, deselect the Select all check box in the Open Drop-down list, and then tick the (blank) check box, as shown in Figure 2, and then click OK.

Figure 2 tick the (blank) check box

3. At this point, the blank lines in the data area will be filtered out, select these blank lines and right-click, and select the Delete Rows command on the shortcut menu to delete the blank rows, as shown in Figure 3.

Figure 3 Selecting a filtered blank line

4, click the next Triangle button to the right of the column heading again, check the (select All) checkbox in the Open Drop-down list, and then click OK. When all the data is displayed on the worksheet, the original blank row has been deleted, as shown in Figure 4.

Figure 4 Worksheet After blank row is deleted

Attention

Click the Sort and Filter button on the Start tab and deselect the Filter option in the Open Drop-down list to exit the data filter state, and the bottom triangle button to the right of the column heading disappears.