# One shortcut. A complete health report on your entire model.

> Ctrl+Shift+R generates a _ModelCheck sheet with per-sheet detail tables and a summary scorecard covering every major risk category.

Page: https://formulaudit.com/features/model-check

Feature: Model Check: Full Workbook Audit

Manually hunting errors and inconsistencies across a 30-tab model takes hours and still misses things.

## The problem with doing this in native Excel

- Excel's built-in error checker covers one sheet at a time with no summary
- No native way to count hardcoded numbers, dead cells, or deep nesting across all sheets
- There is no built-in workbook scorecard; you have to build it yourself

## How Formula Audit XL does it

1. **Press Ctrl+Shift+R.** Run Model Check from any sheet in the workbook. No setup required.
2. **Read the scorecard.** A new _ModelCheck sheet opens with a summary row counting Errors, Circular References, Broken External Links, Hardcoded Numbers, Dead Cells, Long Formulas, Deep Nesting, References to Empty Cells, Hidden Sheets, and Very Hidden Sheets.
3. **Drill into the detail tables.** Below the scorecard, per-sheet tables list every affected cell with its address, formula, and issue type so you can navigate directly to the problem.

## Who needs this most

- Financial model auditors
- Investment banking analysts pre-submission
- Controllers reviewing third-party models
- Model builders doing a final QA pass

Model Check (Ctrl+Shift+R) scans every sheet in the workbook in one pass and writes the results to a new `_ModelCheck` tab you can share, archive, or attach to a review package.

The summary scorecard gives stakeholders a single-page view of model quality. The per-sheet detail tables show exactly which cells to fix and why.

## FAQ

### What exactly does the scorecard count?

Errors, Circular References, Broken External Links, Hardcoded Numbers, Dead Cells, Long Formulas (>200 characters), Deep Nesting (>5 levels), References to Empty Cells, Hidden Sheets, and Very Hidden Sheets. Hidden and very-hidden sheet names are listed explicitly.

### Does it modify my existing sheets?

No. Model Check writes only to a new sheet called _ModelCheck. All your existing sheets are read-only during the analysis.

### How long does it take on a large model?

Most workbooks complete in a few seconds. Very large files with thousands of formulas may take 15 to 30 seconds.

### Can I run it on a protected workbook?

Model Check reads cell values and formulas and does not require sheet password access to report on visible data.

## Related guides

- [How to Audit a Financial Model in Excel](https://formulaudit.com/guides/audit-financial-model-excel)
- [Excel Formula Auditing: Complete Guide](https://formulaudit.com/guides/excel-formula-auditing)
