Quick summary
The Show Formulas feature in Microsoft Excel lets you display every formula in its cell instead of the calculated result, making it easy to audit, debug, and review spreadsheet logic at a glance.
Steps
- Open the spreadsheet where you want to see the formulas.
- Click the Formulas tab in the Excel ribbon at the top of the screen.
- In the Formula Auditing section, click the Show Formulas button.
- All formulas will now appear directly in their cells instead of displaying the calculated results.
