Hey guys,
I'm constantly forced to use my mouse to click another cell after tabbing into a formula in an excel cell and it is driving me nuts. For example, I would type out "=200-su" and tab to get the SUM formula and it won't let me navigate throughout the spreadsheet to select the criteria to sum up. I click a random cell in the spreadsheet and then select the cells to plug into the formula right now but there has gotta be a better way right?
| +24 | How do we get as sharp as possible? | 11 | 51m |
| +18 | Q&A | Analyst | 8 | 4d |
| +15 | Upselling yourself when you’re unqualified | 2 | 10h |
| +14 | Best way to kill time? | 10 | 9h |
| +13 | How Are Cornell 7 / GC Members Affecting Your Bank or Firm? | 5 | 1d |
| 0 | Analyst Y1 - Messed up In First Week | 2 | 9h |
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.
Hit F2 in the sum function and arrow around. If you move left/right in the formula then hit F2 again and you'll be able to select cells.
Aut qui velit vel amet beatae deleniti. Placeat eius delectus impedit ex.
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...