excel absolute range, keyboard short cut

Question

When I was doing absolute or locking a range in EXECEL, I used to use the F4 key instead of $a1 etc.

Noe the F4 key does not work. is there another way to lock the range quickly or do I have do $a$1 etc

Thanks!

Answer 1

Hi @Anne Pojman ,
I suggest you check if your keyboard have Fn key, if yes please click Fn + F4 at the same time.
If your keyboard doesn't have Fn key, I suggest you try to repair Office application:

https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.