Although you can enter the dollar signs manually, you can use the F4 key on your keyboard to add both dollar signs in one keystroke. If you create formulas frequently, this shortcut can save you a lot of time.
What does F4 do in Excel formula?
When entering your formula, press F4 after entering a cell reference. Excel automatically makes the cell reference absolute! If you keep pressing F4, Excel will cycle through all absolute reference possibilities.
How to use F4 in Excel?
Using the F4 key in Excel is quite simple. Think of a situation where you have been working on an Excel spreadsheet and you want to repeat the last action several times. All you have to do is hold down the Fn key and then press and release the F4 key.
Where is the F4 key in Excel?
The problem is not in Excel, but in the computer’s BIOS settings. The function keys are not in function mode, but in multimedia mode by default! You can change this so that you don’t have to press the Fn + F4 combination every time you want to lock the cell.
Why isn’t my F4 key working in Excel?
The problem is not in Excel, but in the computer’s BIOS settings. The function keys are not in function mode, but in multimedia mode by default! You can change this so that you don’t have to press the Fn + F4 combination every time you want to lock the cell.