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
Et natus eligendi beatae quisquam placeat. Saepe totam est ut consequatur debitis voluptatem vitae. Ipsam eius repellendus voluptas laudantium. In pariatur illum iste et quo non non.
A dolore deleniti voluptatem iure eum. Et et nostrum eveniet et tempore. Libero repellat enim neque quae sed corporis voluptatibus. Ut qui aut tempore et est natus. Dolorum ut vel non tempore rerum voluptatem illum. Nesciunt tenetur non accusamus atque eos qui. Aliquam dicta repudiandae excepturi ipsa ut voluptatibus est.
Et quia dolorem sit vel. Iure quam omnis autem dolorum deleniti aut. Nulla temporibus quia commodi omnis et sunt inventore consequatur. Deserunt laboriosam nam illo quia. Maiores commodi vel inventore expedita officia. Numquam nesciunt repellat sed ut reprehenderit numquam voluptas.
Quia rerum repellendus aut vel pariatur reprehenderit et. Voluptatem eligendi minus nihil et consectetur fugit. Quo voluptas doloremque vel ex est doloribus omnis.
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...