View Single Post
  #1   Report Post  
Julian
 
Posts: n/a
Default 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,