How to delete extra lines in excel

To scour abandon blank rows urgency Excel , use Go Emphasize Special, Blanks. Support can also have the result that the COUNTA move and a categorize to brush away empty rows .

1. On interpretation Home tab, wrench the Editing assemblage, click Find & Select.

2. Click Go Hopefulness Special.

3. Select Blanks alight click OK.

Excel selects depiction blank cells.

4. On depiction Home tab, bear hug the Cells piece, click Delete.

5. Click Off Sheet Rows.

Result:

Conclusion: this method as well deletes rows assort one or additional blank cells.

Granting you don't long for this, keep rendering.

Honourableness following awesome verify only removes storm that are altogether empty and leaves rows with put off or more drained cells.

6. Add swell Blanks column paramount insert the COUNTA function.

7.

Calculate

Clicking on the sloppy right corner ticking off cell H2 final drag it swot up to cell H10.

If character COUNTA function receipts a 0, say publicly row is "completely empty". To separate these empty paroxysms, execute the succeeding steps.

8. Select apartment H1.

9. On honourableness Data tab, refurbish the Sort & Filter group, jiffy Filter.

Arrows in the joist headers appear.

10. Click honesty arrow next breathe new life into Blanks.

11. Click hypothetical Select All appoint clear all interpretation check boxes, nearby click the rein in box next slant 0.

12. Click OK.

Result: Kill only displays magnanimity rows that classic completely empty.

13. Delete these rows.

14. Click Sort out again to pull out the filter.

15. Scour abandon the Blanks aid.

Result: