Anchoring multiple cells at once

[MichaelJ300]

Hello all, Wondering if there is a way to anchor multiple cells at once. Highlighting all the cells and hitting F4 doesn't work.

 

[LegendaryAxe]

If by anchoring, you mean turn the relative references in the cells to absolute references, I think you can only do this by rewriting the formulas (this could be easy if it's just one formula copied down -- just change the first formula and then copy it down again) or using VBA. Here's a VBA script I found from an old thread that works:

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