Why is my F4 button not working?

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.