Copy a formula down a set number of times
 

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,

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,