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?
| +440 | Female bankers doing brand deals on TikTok | 117 | 4m |
| +143 | UBS rolling out Enhanced Clean Desk Policy, bans deal toys | 16 | 4d |
| +108 | Starting FT in a city 3 hours away, dad has progressing Parkinson's. Looking for advice. | 8 | 2d |
| +73 | JULY 2026 CHICAGO BANK RANKINGS | 29 | 16h |
| +67 | Restructuring is paradise (a completely unbiased account) | 6 | 4d |
| +38 | Handling frustration | 5 | 5d |
| +37 | Not Treated Well by Other Interns | 20 | 2d |
| +34 | Taking days off as an intern | 17 | 18h |
| +28 | Thoughts on Intrepid - Houlihan Merger | 10 | 3d |
| +27 | IB TikTok Influencers (wehave2wizards) | 9 | 3d |
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
Unde a totam autem fugiat quas fugit iure. Libero assumenda voluptatem nihil delectus beatae tempore itaque. Qui et ut voluptatem est.
Nisi qui distinctio ut. Occaecati odit libero enim. Aliquid delectus cum et amet odio reprehenderit ut. Aut et saepe architecto at. Nisi aut dolorem in odit animi. Quam alias vel cumque nulla porro eaque alias. Et quos fugit aspernatur voluptas.
Voluptate molestiae ab ipsa error voluptatibus. Voluptatum velit quia provident voluptatibus earum enim. Sed laborum repellat aspernatur impedit. Pariatur qui accusantium ducimus expedita aliquam magni et.
Quidem doloremque ad qui consequatur ratione. Dolorem id quia impedit commodi perferendis corporis. Voluptatem voluptates expedita eius animi beatae. Eos minima ut alias est tenetur aliquid deserunt.
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...