Excel processing with too much volume

Use an Excel table to make a template, count some data, and do not have many rows at a time. Results 10 times not enough to reach 20+m, open save is very slow. In addition to using a subtotal, no other. Actually grew so fast.

Baidu to find a simple method. It only takes two steps, yes.

Open the file, select the first line of the blank line below, then use "ctrl+shift+ down Arrow", and the second step, clear with "Ctrl + Minus (-)". Each worksheet is processed and saved immediately. Look at the size and become 17k!.

Excel processing with too much volume