# How to Display Formulas Microsoft Excel

> To display formulas in Microsoft Excel, open your spreadsheet, navigate to the Formulas tab in the ribbon, and click the Show Formulas button within the Formula Auditing section to reveal all formulas in their cells instead of results.

Canonical: https://livedemo.ai/tutorials/how-to-display-formulas-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3ba6ab56e05a00fe315e/preview?step=1

## Steps

1. Open the spreadsheet where you want to see the formulas.
2. At the top, click on the Formulas tab in the ribbon.
3. Find the Show Formulas button in the "Formula Auditing" section and click it.
4. All your formulas will now appear in their cells instead of the results.