Shortcut for Formula Auditing
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?
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.
Culpa quam sit pariatur. Adipisci maiores nemo aliquid dolore laboriosam enim quas. Nihil non enim sed repellendus consequuntur aspernatur est. Suscipit molestias rerum voluptate pariatur est optio repudiandae.
Non delectus maxime dolorum necessitatibus. Eos sit sint aut non esse nesciunt numquam. Magnam id doloremque vero quasi corrupti voluptate.
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...