Another Excel question

Yellow Fang

Legendary Member
Location
Reading
Is it possible to select a cell with the mouse and make it enter the fixed cell number. For example, if I type '=' into a cell and then left-click on cell B2, "B2" appears in the cell. Is there some mouse and key combination that would make "$B$2" appear in the cell, thus saving me the bother of editing it?
 

adscrim

Veteran
Location
Perth
F4 - allows you to scoll through the various fixing options.
 
Top Bottom