Question: what is the formula to delete blank rows in excel?
Answer: Press [F5].
In the resulting Go To dialog box, click Special.
Click the Blanks option and click OK. Doing so selects the blank cells (what you might think of as rows) in the selected range. ... 
Now you're ready to delete the selected cells. ... 
Excel will delete the blank cells from the selected data range.