Excel worksheet functions

[Joe]

Is there a way to select a range of cells and turn to
absolute all at the same time?

 

[Harlan Grove]

Is there a way to select a range of cells and turn to
absolute all at the same time?

In a formula, select a range reference and start pressing the [F4] key. If you
mean change all range references in all formulas in the selected range to
absolute, then see

http://www.google.com/groups?selm=Oxz5#[email protected]

 

[Gord Dibben]

Joe

Only through VBA 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)

'line above can be altered for varying references as below
'(cell.Formula, xlA1, xlA1, xlAbsRowRelColumn)
'(cell.Formula, xlA1, xlA1, xlRelRowAbsColumn)
'(cell.Formula, xlA1, xlA1, xlRelative)

End If
Next
End Sub

Gord Dibben Excel MVP