Forum Discussion

Felix Mathew's avatar
Felix Mathew
Copper Contributor
Mar 31, 2018
Solved

why does F4 cell lock not work in excel 2016 for windows 10

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
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 02, 2018

    Hi 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 http://www.thewindowsclub.com/change-function-key-behavior-windows-laptops.

     

    Hope that helps

    Haytham

Robert Wunderlick's avatar
Robert Wunderlick
Copper Contributor
Aug 20, 2018

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?

  • Robert Wunderlick's avatar
    Robert Wunderlick
    Copper Contributor
    Aug 21, 2018

    Thanks!  That's perfect!

Resources