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?
| +139 | UBS Catastrophic Q1-Q3 26, M&A -17%, Outside Top 10 in Americas, EMEA & APAC | 40 | 8h |
| +63 | PWP acquisition by Piper cancelled | 23 | 14h |
| +45 | No return offer - UPDATE. | 12 | 12h |
| +31 | Evercore poaches Baird DC Defense Team | 24 | 2h |
| +22 | Best Houston Banks for Culture in 2026 | 16 | 11h |
| +22 | Is my MD a grifter? 16 years, 8 firms | 13 | 2m |
| +21 | Lack of talent in IB! | 19 | 20h |
| +18 | Article: UBS Wall Street Rebuild Is a Study in Management Failure | 4 | 9h |
| +17 | Internal lateral from coverage to M&A (focused on coverage) | 4 | 1d |
| +15 | How standard is weekend work in IBD? | 11 | 1h |
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.
Ad nobis quidem nemo et est facere rerum. Neque delectus ea necessitatibus illo assumenda harum illo. Magni unde vel a aut aliquam vel quos. Dolorem ab cupiditate mollitia laboriosam placeat ipsam. Voluptas ut hic tempora doloribus quo sit.
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...