View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Put =A1 in the other cells although I can't understand why you would need the
same formula in 60000 cells!?


Regards,

Peo Sjoblom

"Sam" wrote:

I have the same formula entered in cells A2:A60000, as in cell A1.
However, when I change the formula in A1, I have to (again) copy
it into A2:A60000. Is there a way to avoid this - is it possible to change
the formula in A1 and have it automatically changed in A2:A60000?

Thanks a lot!