fixed cell reference

[Brian Gregg]

Is it possible to switch on automatic fixed cell reference ($)

 

[Jacob Skaria]

In edit mode; place the cursor near the cell reference and press F4.

If this post helps click Yes

 

[David Biddulph]

F4 will toggle between the 4 options for relative & absolute addressing.

 

[Gord Dibben]

No such function to pre-select type of cell references.

Only F4 during or after entry as others have posted.

Or use macros to change a complete range of cells after entry.

Example macro.............

Sub Absolute()
Dim Cell As Range
For Each Cell In Selection
If Cell.HasFormula Then
Cell.Formula = Application.ConvertFormula _
(Cell.Formula, xlA1, xlA1, xlAbsolute)
'Or choose from below
'(Cell.Formula, xlA1, xlA1, xlAbsRowRelColumn)
'(Cell.Formula, xlA1, xlA1, xlRelRowAbsColumn)
'(Cell.Formula, xlA1, xlA1, xlRelative)
End If
Next
End Sub


Gord Dibben MS Excel MVP