Absolute Reference on a Group of Cells

  • Thread starter Thread starter ab
  • Start date Start date
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)
 
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
 
Back
Top