quick way to add dollar signs to cell refs?

B

Bridgerider

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

Bob Phillips

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

Hywel

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

Unfortunately, Paste Link will not solve my problem,
Thanks
Hywe
 
Top