Lock all cell references on page

[sarahrosenberg]

I have a whole worksheet of formulas and I would like to lock the cell reference on every formula. (i.e., convert A4 to $A$4). Is there a quick way to do this for all formulas on a sheet?

 

[VoG]

Try ASAP Utilities http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=102&utilities=97&lang=en_us

 

[sarahrosenberg]

I can't get the ASAP utilities on this computer (admin restrictions). I guess I was hoping there was some simple Fn-F4 sort of solution. (Love your picture/Gin-Soaked Salty Dog! LOL!)

 

[VoG]

Try

Public Sub MyConvertFormula()
Dim c As Range
For Each c In ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
    c.Formula = Application.ConvertFormula(Formula:=c.Formula, fromreferencestyle:=Application.ReferenceStyle, toabsolute:=xlAbsolute)
Next c
End Sub