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" <Bridgerider@discussions.microsoft.com> wrote in message
news:DC46442D-93AE-4157-BD44-40409177035F@microsoft.com...
> 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