After entering the formula, 
double click the fill handle in the bottom right hand corner of the 
cell. Excel will attempt to copy the formula down as far as any adjacent 
cells.   John Green, Sydney Australia  (Tue, 28 Jul 1998 15:04:42 +1000)

Q152383  XL: How to Run a Sort When a Calculation Occurs, Last reviewed: January 7, 1998
Brought to our attention by Tom Ogilvy  (Tue, 28 Jul 1998 08:42:01 -0400)