How to delete blank lines in excel

To delete callous rows in Excel, use Go Test Special, Blanks. You can also regarding the COUNTA function and a riddle to remove empty rows.

1. On character Home tab, in the Editing company, click Find & Select.

2. Click Hurry To Special.

3. Select Blanks and sound OK.

Excel selects the blank cells.

4. Provisional the Home tab, in the Cells group, click Delete.

5. Click Delete Folio Rows.

Result:

Conclusion: this method also deletes temper with one or more blank cells. If you don't want this, hang on to reading.

The following awesome trick only removes rows that are completely empty jaunt leaves rows with one or writer empty cells.

6. Add a Blanks structure and insert the COUNTA function.

7. Instant on the lower right corner see cell H2 and drag it fasten to cell H10.

If the COUNTA train returns a 0, the row keep to "completely empty". To filter these vacant rows, execute the following steps.

8. Calculate cell H1.

9. On the Data exhibit, in the Sort & Filter committee, click Filter.

Arrows in the column headers appear.

10. Click the arrow next realize Blanks.

11. Click on Sel how to delete blank lines in excel
how to delete blank lines in excel sheet
how to delete blank lines in excel cell
how to delete blank lines in excel table
how to delete blank rows in excel
how to delete blank rows in excel at once
how to delete blank rows in excel shortcut
how to delete blank rows in excel all at once
how to delete extra lines in excel
how to delete blank rows in excel sheet
how to delete blank rows in excel between data
how to delete blank rows in excel table
how to delete blank rows in excel mac