Mar 31 2018 08:45 AM
I cant lock my cells using f4 shortcut nor look into them using F2 in Excel 2016. Could someone please help? I'm using Dell inspiron with windows 10
Mar 31 2018 09:38 AM
Felix, i guess for Dell Inspiron we speak about combinations Fn+F4; Fn+F2, etc. Do your functional keys work in other applications (Word, etc)?
Mar 31 2018 09:43 AM
Mar 31 2018 10:04 AM
You are welcome
Apr 02 2018 04:31 AM
I'm moving this conversation into the Excel space so more Excel users can see this question and answer.
Apr 02 2018 06:07 AM
SolutionHi Felix,
The problem isn't in Excel, it's in the computer BIOS settings.
The function keys are not in function mode, but are in multimedia mode by default!
You can change this so that you don't have to press the combination of Fn+F4 each time you want to lock the cell.
To do that, open the BIOS settings on the computer startup, and then find the responsible option to change the function keys mode!
Check this link.
Hope that helps
Haytham
Aug 20 2018 04:42 PM
Thanks for the hints on the fn+F4. Works great when just using my HP Envy x360. But when I dock and use a Bluetooth keyboard (Microsoft comfort keyboard 5050), I can't find a hot-key combination that locks the cell. Any ideas?
Aug 20 2018 09:58 PM
Aug 21 2018 07:26 AM
Thanks! That's perfect!
Mar 26 2020 04:09 AM - edited Mar 26 2020 04:10 AM
My case is a bit different. I have a Dell Latitude 7400, I have "disengaged" the Function (fn) for the F keys, so they work independently, and all F keys work fine except for F4, which doesn't work... @Haytham Amairah
Jul 28 2020 11:20 AM
Apr 02 2018 06:07 AM
SolutionHi Felix,
The problem isn't in Excel, it's in the computer BIOS settings.
The function keys are not in function mode, but are in multimedia mode by default!
You can change this so that you don't have to press the combination of Fn+F4 each time you want to lock the cell.
To do that, open the BIOS settings on the computer startup, and then find the responsible option to change the function keys mode!
Check this link.
Hope that helps
Haytham