Click on a cell reference and then press the F4 key until the $ marks are displayed before both the row number and column number. Double click the formula cell to get into the editing mode.Ģ. You can change cell reference of formula to absolute with pressing the F4 key. Mass anchoring cells (change cell reference to absolute) with Kutools for Excel The following two methods will show you how to deal with it.Īnchoring cells (change cell reference to absolute) with pressing the F4 key For anchoring the formula cells to make the result constant, you need to change the cell reference to absolute in formulas. Normally, when you create a formula, the cell references are relative, so the calculating result will be changed automatically when you copy and paste them to another location.
How to anchoring formula cells (change cell reference to absolute) in Excel?
