When I type formula in A1, say I would like it to be =C40+C41. I select C40 but if I want to move down to C41, Excel automatically goes back to A1 and I need to go through all the cells again to choose C41. What can I do to stop going back to A1 and just stay in C40 after I hit the "+", so that I can then just go down one cell to C41?
| +259 | Why UBS Is the Worst Place to Start Your IB Career | 40 | 1d |
| +216 | UBS 2nd Year Analyst Q&A (2026) | 41 | 3h |
| +93 | What's your craziest "hardo" story? | 16 | 12h |
| +62 | Indiana University Fraternity Pipelines | 36 | 2d |
| +52 | Rogo AI | 22 | 5h |
| +49 | Elite Boutique interview questions | 17 | 1d |
| +48 | Suspended for a Year | 19 | 2d |
| +47 | Wolf of Wall Street vs. Reality: Anyone else feel scammed by the movies? | 18 | 4h |
| +30 | Rate my non-target resume | 15 | 6h |
| +24 | RX Firm Lateral Advice | 15 | 10h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Based on the most helpful WSO content, here's a solution to your problem:
When entering a formula in Excel and you want to navigate between cells without being taken back to the original cell, you can use the following steps:
This method ensures that you stay in the cell you are editing and can easily navigate to the next cell without being taken back to the original cell.
Additionally, you can use the mouse to click on the cells directly if you prefer not to use the keyboard for navigation. This can sometimes be quicker and avoids the issue of jumping back to the original cell.
If you frequently encounter this issue, consider using the F2 key more often to enter edit mode directly in the cell you are working on. This can streamline your workflow and reduce frustration.
Sources: EXCEL cheats megathread, EXCEL cheats megathread, Common Hotkeys - What do you use?, Common Hotkeys - What do you use?, Favorite Excel Shortcuts
Dolor id dicta et et voluptas accusantium. Eum ut autem omnis iste quisquam rem. Corporis nihil officiis mollitia ipsam in magnam. Omnis dolorem sit quia rerum.
Ut quam praesentium non ratione. Et ea et eum ratione totam. Quam quam odit voluptate sequi. Et earum quas id ipsum velit consequatur magnam.
Quod in ad ut dolorum odit. Dolorum vel pariatur dolore qui quia.
Quam ipsa cupiditate voluptates aut sunt qui consectetur. Quo ea ea soluta molestiae possimus doloremque. Nobis at deserunt pariatur repellat error dolor quod. Beatae labore quia culpa sit eum temporibus id et. Eaque voluptatibus quia odit voluptatem omnis fuga.
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...