Forum Discussion
Make all cells references in a long formula absolute
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
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
SergeiBaklanThanks for your response on this issue. I was struggling with it for quite some time, and felt certain there was a simpler way. I have dozens of these tings and copying them all manually was mind-numbing.
SFwriter , glad it helped
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.
For me Ctrl+A works both in the formula bar and the cell.
I realise that my proposed solution was overkill in that I set out to change multiple relative references to a given cell without changing other relative references that may exist within the same formula.
- I appreciate it and thank you Sergei!
Sam, you are welcome
