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

"Julian" wrote in message
...
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,