keep cell referenses i formula

[jocke]

Hi guys,

i have an really annoying problem.
i have some formulas referring to cell A1
when i copy and paste the data in A1 to B1, the formula then refer to cell B1.
How can i avoid the referens to change cell.

/ jocke

[sweep]

You could subsititute the cell reference with an INDIRECT function.

ie Instead of =A1, use =INDIRECT("A1")

[arthurbr]

You can use an absolute reference

Please Login or Register  to view this content.