Forum Discussion
when type a formula, i would like to move from the active cell not the formula cell
Thanks a lot for your reply. Sorry that I didn't make myself clear. My question is more basic and may sound even stupid...
If I want to type a formula in a cell, say A1, I need to reference other cells to complete the formula. Using the example above, if I put C4+C5 in cell A1, My cursor is current in A1 and I firstly need to use the down array key to move to Row 4, then the right arrow key to move to column C (using keyboard not mouse). After that I will type in "+", then go to C5. However, sometimes it is simply for me to press the down array key one more time, as the cursor starting from C4 to move around, sometimes the cursor goes back to the formula cell (A1) and i need to press the down array key to Row 5 and then the right arrow key to column C again, duplicating the steps have done before.
I would like to ask if there is any setup I can change the way it works? thanks!