No, you can't. You would have to use a macro for this.
But here's a way to automate it a bit. Let's say the actual data occupies
cells A1:H985. In I1, put the number 1, then Edit/Fill/Series to fill with
sequential numbers down to 985. In J1, put the formula
=IF(COUNTA(A1:H1)=0,1,0)
and copy down. Then sort on column J. The "blank" rows will be at the bottom.
Now you can delete them manually. Then sort again on column I to get the rows
back into their original order. Then delete column J.
If this is something you need to do repeatedly, a macro would be a better
approach.
