Select B2 again, press F5, type in B3005, hold down shift key and press enter,
press ctrl + d


Regards,

Peo Sjoblom

"KiwiBrian" wrote:

After entering a formula into a cell, say b2, how do I tell excel to copy
the formula right down to b3005?

TIA
Brian Tozer