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
I appreciate it and thank you Sergei!
Sam, you are welcome