Copy a formula down a set number of times

[Guest]

I'm trying to figure out how I can copy down a formula in a column a set
number of times. I have data where I need to have a formula copied into about
1000 rows. I do this by dragging the formula down 999 rows, and this is
becoming tedious. Is there an easy way to tell excel to copy down the formula
999 times, after writing it in, say, cell A2?

Thanks,

 

[Anne Troy]

Try something like this, Julian:
Ctrl+G
Type A2:A1000
Hit Enter.
Type your formula.
Hit Ctrl+Enter.
************
Anne Troy
www.OfficeArticles.com