Easier to edit a formula

[shadow12345]

Hi all,

This is very odd question but I quite often refer to the same cell a number of times in a formula. When I go to edit the formula I press F2 and pull the coloured box to the correct cell.... is there a way to move ALL of the colour boxes on with one click and drag?

Im just curoius really, but it must be possible i should think.

 

[shg]

No, one reference at a time.

 

[mikerickson]

You could substitute a named range for the cell, then editing the definition of the name would change all the arguments in all formulas with one go.