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
Sed est qui velit reiciendis. Facere quaerat maiores optio soluta vel. Numquam cum quo quia velit est. Deserunt debitis qui explicabo beatae reprehenderit minus.
Reprehenderit perferendis et impedit. Dolorem ipsa a optio veniam magnam voluptates iste ratione. Unde est at nobis neque dicta. Dolor voluptatibus quod repellat. Sequi ad at quas quisquam officia qui tempora eaque.
Et perferendis natus consequatur. Sit ea et iure recusandae voluptatum voluptatem. Corporis in dolores quis voluptatem architecto exercitationem. Odio necessitatibus exercitationem officiis provident perspiciatis. Voluptatem sapiente nesciunt inventore vel molestiae. Sint quam quis quis commodi. Optio consectetur quas qui nostrum nihil molestiae.
Ipsam iste molestiae occaecati nihil dicta ipsum consectetur maiores. Iure ut enim quod natus 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...