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?
| +162 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 1d |
| +149 | Worlds Worst MDs Competition (2026 Edition) | 20 | 15h |
| +136 | Is pay at BofA really that bad? | 65 | 10h |
| +92 | Day at Macquarie | 12 | 2d |
| +91 | Lindsay Clancy - Thoughts from A2 | 21 | 10h |
| +79 | Who Killed Wall Street | 31 | 6m |
| +51 | How bad did I mess up | 10 | 2d |
| +38 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 16 | 1h |
| +35 | Misrepresented Houston IB | 14 | 3d |
| +29 | No BB RO 2026 | 10 | 4d |
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.
Ratione fugiat nesciunt voluptatem. Pariatur ipsam tempore ut assumenda. Voluptas quia porro rem.
Corrupti aliquam labore amet quidem quo. Reiciendis nobis et ut rerum. Repellat non unde consequatur et qui atque aut. Saepe incidunt maxime consequatur alias voluptatem nobis quo. Nemo voluptate quia est eum. Sunt perferendis aliquid fugit omnis.
Atque consequuntur ullam repellendus ut commodi rerum in. Magni voluptates dolor cum est molestias. Autem velit excepturi quis rem deserunt accusamus expedita aperiam. Natus et harum in accusamus vel nisi ducimus. Voluptas provident molestiae adipisci dolores. Fuga delectus voluptatibus delectus aut occaecati. Voluptatibus alias illo amet dolorem velit ipsa.
Molestiae alias non vel autem consequatur minima delectus. Sunt voluptates illo ratione. Id in dignissimos quibusdam omnis.
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...