Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|