Forum Discussion
uptown100
Jun 03, 2024Copper Contributor
I need help with cell referencing
When making a cell relative or absolute is it the F2 or F4 key that I need to press or is there another key that needs pressing like Control+Shift+F2, or Control+Shift+F4, because when all I press is...
uptown100
Jun 04, 2024Copper Contributor
good looking out, Hans Vogelaar. pressing fn+f4 worked. I wish they would've mentioned that in the youtube tutorials I've been watching.
HansVogelaar
Jun 04, 2024MVP
If you wish, you can "lock" the Fn key so that you only need to press F4.
Your keyboard should have a key with a lock symbol or the text "fn lock" on it - on my keyboard it is the Esc key, but it might be different on yours.
Pressing Fn + this key (so for me Fn+Esc) will lock Fn. Pressing Fn + this key again will turn the Fn lock off.