Tags: absolutereference, cell, celllocation, content, excel, fix, force, formula, function, insert, location, microsoft, msdn, software

How to really fix a cell location

On Microsoft » Microsoft Excel

1,596 words with 2 Comments; publish: Sun, 01 Jun 2008 13:57:00 GMT; (30678.13, « »)

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

All Comments

Leave a comment...

  • 2 Comments
    • =indirect("a1")

      will always point to A1 no matter what you do.

      =sum(indirect("a1:a10"))

      will always add A1:A10

      EpsilonRho wrote:

      > 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

      Dave Peterson

      #1; Sun, 01 Jun 2008 13:58:00 GMT
    • Thank you very much!

      Gene

      "Dave Peterson" <petersod.excel.todaysummary.com.verizonXSPAM.net> wrote in message

      news:467C7290.FE968D9.excel.todaysummary.com.verizonXSPAM.net...

      =indirect("a1")

      will always point to A1 no matter what you do.

      =sum(indirect("a1:a10"))

      will always add A1:A10

      EpsilonRho wrote:

      > 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

      Dave Peterson

      #2; Sun, 01 Jun 2008 13:59:00 GMT