Here's how to do it:
- Open the spreadsheet where you want to see the formulas.
- At the top, click on the Formulas tab in the ribboHow to Display Formulas Microsoft Exceln.
- Find the Show Formulas button in the "Formula Auditing" section and click it.
- All your formulas will now appear in their cells instead of the results.