How to change a formula in one cell and have these changes appear
 

Not without using a macro that copies it for you. However, you may find it
easier if you first select cells A1:A60000, enter your new formula, then
press Ctrl-Enter. Also, it's very fast to select all those cells if you use
the keyboard. With A1 selected, hold the Shift key while pressing first the
End key & then the down arrow key


"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!

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!