# Guides to auditing Excel models.

> Practical guides to auditing Excel models: circular references, tracing precedents and dependents, external links, inconsistent formulas and more.

Page: https://formulaudit.com/guides

- [How to Find Circular References in Excel](https://formulaudit.com/guides/find-circular-references-excel): How to find, fix and remove a circular reference in Excel: the Error Checking menu, the status bar, trace arrows, iterative calculation and a free finder.
- [Trace Dependents in Excel: Shortcut & Other Sheets](https://formulaudit.com/guides/trace-dependents-excel): Trace dependents in Excel in one click or with Alt+M,D. See every formula that uses a cell, follow dotted arrows to other sheets; Ctrl+] jumps on-sheet.
- [Trace Precedents in Excel: Location & Shortcut](https://formulaudit.com/guides/trace-precedents-excel): Trace Precedents sits on Formulas > Formula Auditing (Alt+M,P). See which cells feed a formula, follow arrows to other sheets, and jump with Ctrl+[.
- [How to Break External Links in Excel](https://formulaudit.com/guides/break-external-links-excel): Break external links in Excel with Data > Edit Links, then find the hidden links it misses: names, charts, data validation and conditional formats.
- [Excel Formula Auditing: Complete Guide](https://formulaudit.com/guides/excel-formula-auditing): Excel formula auditing: Trace Precedents and Dependents, Show Formulas, Evaluate Formula, Error Checking and a workflow for large financial models.
- [How to Show All Formulas in Excel](https://formulaudit.com/guides/show-all-formulas-excel): How to show all formulas in Excel with Ctrl+` or the Formulas ribbon: printing formulas, spotting hardcodes and the limits of formula view on big models.
- [How to Find Errors in Excel Spreadsheets](https://formulaudit.com/guides/find-errors-excel): How to find errors in Excel with Error Checking, Show Formulas and Evaluate Formula: #REF!, #DIV/0!, #VALUE!, and the logical errors that show no code.
- [Inconsistent Formula in Excel: Meaning & How to Fix](https://formulaudit.com/guides/inconsistent-formulas-excel): The green-triangle inconsistent formula warning means a cell differs from its neighbours. Check, fix or ignore it, and scan a whole model with an add-in.
- [Excel Trace Dependents & Precedents Shortcuts](https://formulaudit.com/guides/trace-precedents-dependents-shortcuts): The Excel shortcut to trace dependents is Alt+M,D and to trace precedents Alt+M,P. Ctrl+] and Ctrl+[ jump to the cells; Alt+M,A,A clears the arrows.
- [How to Audit a Financial Model in Excel](https://formulaudit.com/guides/audit-financial-model-excel): How to audit a financial model in Excel, step by step: circular references, errors, precedent tracing, external links, consistency and version checks.
- [Enable Iterative Calculation in Excel](https://formulaudit.com/guides/enable-iterative-calculation-excel): Turn on iterative calculation in Excel for Windows and Mac, set Maximum Iterations and Maximum Change, and learn when a circular model is safe to run.
