At my bank, we have an Excel shortcut (Ctrl+Shift+M) that pulls up a formula auditing toggle box. This allows me to easily trace cells and check work. Haven't been able to find this shortcut on my personal Excel. Anyone know what add-in / system this is part of? If not, has anyone figured out a similar shortcut to use for auditing cells?
| +374 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 44 | 1h |
| +291 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 31 | 1h |
| +269 | AI is insane | 37 | 1h |
| +264 | I Snuck Into UBS Office And Took A Shit On The Floor | 26 | 5h |
| +247 | TPH V.S. Mizuho [HOU] | 32 | 41m |
| +205 | Best Power/Renewables/Energy Teams? | 32 | 55m |
| +201 | Useless associates | 36 | 1h |
| +182 | Differences in Restructuring Teams? | 33 | 1h |
| +177 | Centerview HC group falling off? | 28 | 1h |
| +152 | Shame on you Evercore - SA 28 | 41 | 2h |
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, while the specific shortcut (Ctrl+Shift+M) you mentioned might be a custom setup or part of a proprietary add-in at your bank, there are built-in Excel shortcuts and tools for formula auditing that you can use:
Trace Precedents: Ctrl + [
This highlights the cells that feed into the selected cell.
Trace Dependents: Ctrl + ]
This highlights the cells that depend on the selected cell.
Show All Formulas: Ctrl + ~
This toggles the display of all formulas in the worksheet.
F5 (Go To Special): Use this to navigate to specific cell types, like formulas, constants, etc.
If you're looking for a more advanced solution, consider using Excel add-ins like SmartShortcuts (download link: http://www.smartshortcuts.com/</a">http://www.smartshortcuts.com/) or other formula auditing tools that might replicate or enhance the functionality you're used to.
Sources: EXCEL cheats megathread, EXCEL cheats megathread, Excel: Tools, Add-Ins, and Macros, Excel: Tools, Add-Ins, and Macros, Most used excel shortcuts?
There are several add-ins you can use to help you audit a formula.
A free add-in is called Tracy. The shortcut to inspect a formula is CTRL + Q, after which you can cycle through each formula element quickly.
Other people have also used Arixcel and Macabacus in the past, but they charge monthly :(
Following.
Nulla ullam totam nihil accusamus cupiditate. Laboriosam ut dolor dolorum est aperiam quos. Minima quis consequuntur ipsam expedita rerum. Nulla voluptas quia voluptas totam optio nam in. Natus dolorem aliquid harum dolores quis sit.
Tempora atque ad aut. Harum id quo dolores et et ullam. Maxime et distinctio corrupti temporibus quae maxime totam fugiat.
Temporibus qui ipsa sit incidunt. Et tenetur officia omnis enim possimus.
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...