Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |