How to really fix a cell location

  • Thread starter Thread starter EpsilonRho
  • Start date Start date
E

EpsilonRho

How can I force a formula to use always the content of the same cell
location even when the insert function has been used. Using the absolute
reference method (for example $A$1) doesn't work because if the content of a
specific cell has been moved the absolute reference moves with it.
Thanks,
Gene
 
=indirect("a1")
will always point to A1 no matter what you do.

=sum(indirect("a1:a10"))
will always add A1:A10
 
Thank you very much!
Gene

=indirect("a1")
will always point to A1 no matter what you do.

=sum(indirect("a1:a10"))
will always add A1:A10
 
Back
Top