Finally, Excel would automatically apply formulas ... In the Sort Warning dialog box, choose "Expand The Selection" and click "Sort." You will then see all your blank rows move to the top, which ...