quick way to add dollar signs to cell refs?

[Bridgerider]

Does anyone know a quick was to add dollar signs to cell refferences on a
worksheet so that the refferences remain fixed?

[Bob Phillips]

select the cell, F2, select the formula, then F4. each successive F4 toggles
between the absolute/relative combinations.

--
HTH

Bob Phillips

"Bridgerider" <[email protected]> wrote in message
news:[email protected]...
> Does anyone know a quick was to add dollar signs to cell refferences on a
> worksheet so that the refferences remain fixed?

[Hywel]

Further to this, is it possible to apply this over a large selection of text where dollar signs are needed, but were not added in the first place.

Unfortunately, Paste Link will not solve my problem,
Thanks
Hywel