Yes I agree. I use names currently because the feature i mentioned is not
available. I think new users understand absolute references before they learn
about names. If would be nice if when you named a cell it would give you the
option at that point to cascade that name through all of your formulas.
Instead of having to go through the menus.

"Niek Otten" wrote:

You could define a name for the cell. That way it each use of the name in a
formula would reference that cell.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Unitrip" wrote in message
...
It would be nice if you could set an absolute reference property in on
cells
in your worksheet. By setting this property each time the cell reference
was
used in a formula it would automatically be set as a absolute reference. I
think this would improve productivity by reducing the time it takes to fix
these references.