Sorry if this has been asked before and I just can’t find the right keywords to pull it up!
In calc, when I’m selecting cells in a formula the cursor(?) stays wherever the last cell I selected was, instead of snapping back to the active cell.
For example, I’m in B2 and I want to enter a formula like =if(a2=b1,b1,""), here’s what I need to type to get that formula (assuming I want to use arrow keys to navigate around):
Calc: = i f ( [left] = [up] [right] , [right] [left] , " " )
What I’m used to: = i f ( [left] = [up] , [up] , " " )
Is there any way to change it so it snaps back to the active cell, the way I’m used to, rather than sticking with whatever was last chosen in the formula?
Thanks!