Absolute Reference on a Group of Cells

[ab]

How can create an absolute reference on a group of cells

 

[Chip Pearson]

Use the '$' character. E.g., $A$1:$C$10

Note, though, this will change if you insert rows in 1:10. You can also use
INDIRECT("A1:C10") which prevents Excel from changing the reference when a
row in inserted.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

 

[Gord Dibben]

For a range of cells you could use a macro to change all at once.

Sub Absolute()
Dim cell As Range
For Each cell In Selection
If cell.HasFormula Then
cell.Formula = Application.ConvertFormula _
(cell.Formula, xlA1, xlA1, xlAbsolute)
End If
Next
End Sub


Gord Dibben MS Excel MVP