Re:Why does F4 cell lock not work in excel 365 for windows 10 @ Naheed Mirwrote: This is because the function keys are in the multimedia mode, not in function mode. Change it to function mode. Hi Naheed Mir , Thank you for your assist , can you tell me how to ...
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....