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?
| +134 | Restructuring: Anti-climactic Experience | 36 | 4h |
| +109 | IB Net Worth / Savings Check | 51 | 4h |
| +99 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 25 | 1h |
| +81 | Stop sleeping on UBS - it’s pretty good | 29 | 8m |
| +54 | 2026 VAULT PRESTIGE RANKINGS | 30 | 1h |
| +39 | AI + Financial Modelling | 12 | 1d |
| +31 | Hardest interview experiences? | 16 | 1d |
| +28 | Summer before college | 17 | 19h |
| +26 | Current State of UBS in North America | 8 | 2d |
| +23 | Cold apply for FT recruiting? | 5 | 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, 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.
Voluptas sunt et neque autem est labore illo cupiditate. Porro maiores voluptate hic at molestias et. In aut ea cupiditate sed eos qui. At dicta laborum quae asperiores vitae et consequatur. Quis consequuntur beatae itaque in qui enim alias unde. Dignissimos debitis perferendis laboriosam. Assumenda eum quas perferendis sunt et commodi.
Quis autem eos quia atque ea eos. Totam debitis consequatur consequatur debitis similique. Consequatur enim vero at possimus vitae. Necessitatibus repellendus aut omnis libero consequatur et.
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...