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
Hi Sergie:
When I do Ctrl+A in the formula bar it doesn't select the entire formula. It doesn't do anything. Am i doing something wrong?
Thanks,
Sam
Sam, perhaps you are not on latest Excel, couple of years ago Ctrl+A didn't work, see for example our discussion here https://techcommunity.microsoft.com/t5/Excel/Editing-text-in-a-cell-Ctrl-A-doesn-t-select-all-ctrl-backspace/m-p/62354. Not sure when it was introduced.
Anyway, select in formula bar as well by Ctrl+End->Ctrl+Shift+Home or like.
PeterBartholomew1 , you are right, if Ctrl+A works it works in both.