Forum Discussion
I need help with cell referencing
You have to editing the cell, either in the formula bar or in the cell itself.
Select one cell reference (such as K2) or one range reference (such as M3:M24) within the formula, and nothing else.
Then press F4. Each press will change the reference. For example, K2 will become $K$2, then K$2, next $K2, and finally K2 again.
Thanks for getting back to me, but I've already tried what you're suggesting and nothing happens, that's why I'm asking is F4 the only key you have to press, or do you have to hit Control+**bleep** and F4, or something else? Am I hitting the wrong function key or something? I'm hitting the function keys at the top of the keyboard.
Does your keyboard have a Fn or fn key? If present, it is usually located next to the left-hand Ctrl key.
Try pressing Fn+F4.
- good looking out, Hans Vogelaar. pressing fn+f4 worked. I wish they would've mentioned that in the youtube tutorials I've been watching.
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.