This is because they are assigned as media keys such as volume up/down or for other purposes. While F4 simply works for most keyboards, some require you to press the Fn/ F-lock key along with it. Then, select an item and press the F4 key to change its cell reference. To enter the edit mode, press the shortcut key F2 or double-click on the cell. However, if you edit the cell contents, you cycle through the different cell references in a formula. If you just select the cell and press F4, you repeat the last single action. On Windows, F4 works differently depending on whether you are in the edit mode or not. In this case, clean the keyboard and see if the key works.Īlso, you can check if the F4 key, in particular, isn’t working on sites that test each key on the keyboard. Or, you simply need to press harder for them to work. Sometimes, dirt and dust accumulate on your keyboard, which stops the keys from being pressed in the first place. While there may be technical issues behind the F4 key not working, ensure the key actually works. Also, check if the key isn’t working for other excel files. Using corrupted/outdated keyboard driversīefore moving on to the fixes below, try closing the excel workbook/worksheet and re-open it.

The F4 key is physically non-functional.Not pressing the Fn/F-lock key with the F4 key.Some of the possible ones are as follows: There are various reasons why F4 isn’t working as expected in Excel.

Excel command buttons stopped working