Home » Questions » Computers [ Ask a new question ]

Prevent Excel from updating absolute references when target is moved

Prevent Excel from updating absolute references when target is moved

I would like to prevent OpenOffice Calc or Microsoft Excel from updating absolute references when their target cells are moved.

Asked by: Guest | Views: 69
Total answers/comments: 1
Guest [Entry]

"You can try Excel's INDIRECT() function:

INDIRECT(ref_text,a1)

For example, if you always want to refer to cell A1, use the following syntax in cell B2:

=INDIRECT(""A1"")

In this fashion, B2 will always be equal to what A1 returns. For more info on this function, visit this page."