Enter the formula in cell A1
Copy cell A1
Hit function key F5
Type A2:A1000
Hit Enter or click on OK
Then EditPaste

Biff

"Crisco Kid" wrote in message
...
How can I replicate a formula from, say, A1 thrugh A1000, without having
to
physically drag all the way from row 1 to 1000?