You can delete blank rows in Excel using several tricks and shortcuts. Check out these 5 fast ways to remove blank or empty rows in your worksheets.
You can also use the COUNTA function and a filter to remove empty rows. 1. On the Home tab, in the Editing group, click Find & Select. 2. Click Go To Special. 3. Select Blanks and click OK. Excel selects the blank cells. 4. On the Home tab, in the Cells group, click Delete. 5. Click Delete Sheet Rows. Result: