How do I anchor a cell/create absolute ref. while clicking on it?

D

dsapan

I know that I can manually go in to a formula and put a "$" to anchor a cell
(i.e., create an absolute reference), but I remember there being a way that I
could use a key stroke while clicking on the cell that I want to anchor.

Thanks for your help!
 
D

Duke Carey

The F4 key cycles through
complete absolute,
absolute row relative column
relative row absolute column
complete relative
 
Top