Microsoft Excel Cell reference make constant

[Trish]

In Microsoft Excel how to make cell reference constant.
For example there is a formula in U2 cell "=R3" (without quotes).

Even after the cell R3 moves down, the formula in U2 cell should not change
should remain "=R3"

Thanks for any replies and help.

Trish

 

[Malke]

In Microsoft Excel how to make cell reference constant.
For example there is a formula in U2 cell "=R3" (without quotes).

Even after the cell R3 moves down, the formula in U2 cell should not
change should remain "=R3"

Thanks for any replies and help.

Trish

You should post to the Excel newsgroup where you'll have the attention
of Excel experts (and I'm not one, sorry!).

microsoft.public.excel

Malke

 

[Gordon]

In Microsoft Excel how to make cell reference constant.
For example there is a formula in U2 cell "=R3" (without quotes).

Even after the cell R3 moves down, the formula in U2 cell should not change
should remain "=R3"

Thanks for any replies and help.

Trish

$R$3 is how you do it.

 

[alanglloyd]

Gordon wrote:

$R$3 is how you do it.

With cell formula in the top entry line selected, pressing F4
repeatedly cycles through ...

=$R$3
=R$3
=$R3
=R3

Alan Lloyd

 

[Gordon]

Gordon wrote:


With cell formula in the top entry line selected, pressing F4
repeatedly cycles through ...

=$R$3
=R$3
=$R3
=R3

Alan Lloyd

Why are you telling me this? I already know it!