Excel question - staying in the same area to select two cells
I need Excel help from qualified monkeys. I don't know if this is the right forum, but here we go.
Is there a way to stay in the same area when you want to reference another cell nearby?
I think it is best explained with an example. Say you have a long vertical model. At the bottom of the model, where you are currently working, you want to show the sum of cell A1 and A2 (all the way at the top), so the formula is "=A1+A2".
However, when you have entered "=A1" and hit plus, you are sent back to the bottom of the model, and have to work your way up again to select A2. So, my question is: is there a way to hit "+" but stay in the area to easily select cell A2?
I would like to add: I know that you can freeze panes. But I am talking about the case of one-offs.
Not totally understanding your issue, but changing the behavior of the Enter key may be your solution.
https://www.causal.app/excel/specifying-the-behavior-of-the-enter-key
Instead of adding individual cells here, do sum(A1:A2). You will only need to go all the way to the top once. Sum in general is best, as you can just add commas and keep moving around without going back to the cell with your formula in it
Recusandae reprehenderit sit dolorem nam et ut. Expedita quia aut voluptatem animi. Est eum dolorum nobis dolor suscipit nemo quae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...