Another way to do it is to use te address bar on the left of the formula bar.

1. Enter A1:A9000 in the address bar
2. control+c to copy it
3. Enter B1:B9000 in the address bar
3. control+v to paste it

Just a twist.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Dave F" wrote:

Assume the range to which the formula is being applied is A1:A9000, and the
formula is being applied to cells B1:B9000.

Go the bottom of the range by selecting cell A1 and hitting CTRL + down
arrow. Go to B9001 and enter a period, or some other holding character. Hit
CTRL + Up arrow to go to B1. Enter your formula. SHIFT + CTRL + DOWN arrow.
CTRL + D.

Dave
--
Brevity is the soul of wit.


"chiechka" wrote:

Any suggestions on how to copy a formula to 9000 rows?