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

"dsapan" wrote:

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!