Forum Discussion
Solved
Make all cells references in a long formula absolute
Hello All: I have a long formula with many different cell references. Is there a way to make all the different cells references absolute in one shot without F4 every cell reference in the formula...
Sam, you shall select entire formula to do that.
In cell:
F2 (or double click)->Ctrl+End->Ctrl+Shift+Home->F4
In formula bar
Ctrl+A->F4
Define a Name to reference the cell (by default it will be an absolute reference) then use
Apply Names...
on the Name Manager ribbon tab to replace the direct reference by the Name.
Not that I have much experience of doing this, since I ban direct references from my workbooks in the first place.
Thank you Peter!