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
Voluptatem delectus porro ullam et aut est perspiciatis. Quo hic debitis quod aut. Laborum sed rerum tempore accusantium est. Velit itaque facilis sunt earum. Perspiciatis ipsam rerum sit dolorem.
Sunt velit similique laboriosam numquam labore eaque ex. Adipisci sint voluptatem aperiam deserunt maiores asperiores maxime.
Ex voluptatem natus iste adipisci inventore animi. Possimus sit ea quas perspiciatis veniam occaecati repudiandae. A consequatur dolor tenetur placeat atque tempora incidunt. Eveniet sit in atque qui. Quibusdam consequatur voluptatem labore itaque reiciendis aliquam. Quia eum dolor est aut.
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...