F4 key in Excel formula

When we write absolute, relative or mixed Cell reference in Excel formulas, we can either type the $ (Dollar) symbol manually or we can use F4 key to insert $ (Dollar) symbol automatically. You need to remember below points when you use F4 key to insert $ (Dollar) symbol in Excel formulas.

  • The Cell where you are trying to write the formula must be in the "Enter mode".
  • You need to type the "=" symbol as the first character of the formula, to tell Excel that you are trying to write a formula.
  • You need to keep the cursor at the beginning of the Cell address at the middle of the Cell address or at the end of the Cell address.
  • Press the F4 key only once to create absolute Cell reference.

Please note that pressing the F4 key different number of times can cause different effect in Cell address in an Excel formula.

  • Pressing the F4 key once will create an absolute Cell reference (Example, =$B$9)
  • Pressing the F4 key twice will place the $ (Dollar) symbol before the Row number. $ (Dollar) symbol before Row number means that, the Row is fixed and the Column is relative (Example =B$9)
  • Pressing the F4 key thrice will place the $ (Dollar) symbol before the Column letter. $ (Dollar) symbol before Column letter means that, the Column is fixed and the Row is relative (Example =$B9)
  • If you press the F4 key four times, all the $ (Dollar) symbols are removed from the Cell address (Example =B9).

Related Tutorials
Cell reference (Cell address)
Range reference
What are Excel formulas
How to write formulas in Excel
How to see all formulas in Excel sheet
Mathematical operators in Excel
Comparison operators in Excel
Concatenate (&) text operator in Excel
Cell or range reference operators in Excel
Union and Intersection of Excel ranges
Operator Precedence in Excel
How to change the operator precedence in Excel
Error messages in Excel Formulas
Hash error in Excel (#### in excel)
Multiple parenthesis in Excel formulas
Trace error in Excel formulas
How to remove trace error arrows in Excel
Relative and absolute reference in Excel
F4 key in Excel formula
Mixed Cell reference in Excel