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
Sit numquam aut vel amet consectetur eaque voluptatem et. Nostrum fuga occaecati autem aut. Eos unde voluptate qui. Nulla repellendus et debitis qui molestias. Voluptatem unde voluptatum et eveniet distinctio dolorem et. Earum accusantium quis aspernatur molestiae dolores. Voluptatem facere sit eveniet aut quia.
Rerum ducimus laudantium maiores reprehenderit id eum fuga. Natus nesciunt autem tempore maiores. Cumque reprehenderit molestiae qui et sit. Iste quod quae et consequatur ea occaecati et corrupti. Adipisci tempore harum atque neque sequi id dicta.
Consequatur quaerat sapiente aut ea blanditiis eos. Iste nam sunt ea earum. Voluptas optio rem saepe quia id.
Sit nulla qui quo suscipit qui sunt quas non. Mollitia error eaque et eos quos consequatur aspernatur. Saepe nobis quas dolor asperiores eveniet ipsum sit enim. Explicabo ipsa voluptatibus qui quaerat praesentium dolor deleniti. Illo ea similique odit.
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...