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
Hello SamFares,
To my knowledge, there is no quicker way than simply using F4 on each cell reference. My suggestion would have been to use find and replace (i.e. find G and replace with $G$) but seeing as though your formula uses cell references beyond the first 26 columns (i.e. LC1, LC2, LL, etc...) this would complicate things. Without creating a macro, I'm afraid my best suggestion is to simply use F4.
Sorry if this isn't the answer you were looking for!
Thank you PReagan!