Post a few examples of your formulas and what you want to change.

Might be as easy as the difference between relative and absolute references.


Gord Dibben MS Excel MVP

On Mon, 15 Dec 2008 13:50:06 -0800, 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 spreadsheet 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?