Re: Change All Instances of a Cell Reference in a Formula

Tech-Archive recommends: Fix windows errors by optimizing your registry

Search and replace will work, but it's a little awkward when already
modifying your formula graphically. Sometimes it forces you out of the cell,
and sometimes it modifies the formula in the background without updating the
current display. Being able to drag all the references at once would be
cleaner, but maybe there is no way to do this. Thanks for the suggestion.


"Chris Premo" wrote:

AlwaysFroosh! wrote:

Is there an easy way to change all instances of a cell reference with
one action? For example, when you enter a particular cell, Excel
hightlights on the spread*** all of the references within that
formula, and if you click on the border of one of the references, you
can drag it to a new location. However, if you have more than one
reference to that cell within the formula, it only changes one of
those references, and you end up having to drag the cell repeatedly
for each reference. I was thinking maybe there would be a shortcut
like holding control or alt or some other combination to drag all of
them at once, but I can't find it. Does anyone know of a shortcut
like this?



Search and Replace (Ctrl-H)????



--


.

Quantcast