fixed cell reference
 

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

fixed cell reference
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Brian Gregg" wrote:

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

fixed cell reference
 

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

"Brian Gregg" wrote in message
...
Is it possible to switch on automatic fixed cell reference ($)

fixed cell reference
 

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

On Thu, 26 Nov 2009 09:57:01 -0800, Brian Gregg
wrote:

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