How to Show Formulas Instead of Results in Microsoft Excel

When working with complex spreadsheets in Microsoft Excel, cells normally display calculated values rather than the underlying mathematical logic or function syntax. While this is ideal for reports and presentation data, reviewing a spreadsheet for errors, auditing cell dependencies, or understanding financial models requires inspecting the actual formulas across multiple rows and columns.

Instead of manually clicking on each individual cell to read the formula bar, Excel provides a built-in toggle that switches the entire worksheet from “Result View” to “Formula View”. In this mode, every calculated cell reveals its exact formula syntax simultaneously.

Method 1: Use the Keyboard Shortcut (Fastest)

The quickest way to toggle formula visibility across your active worksheet is with a universal keyboard shortcut:

1. Open your spreadsheet in Microsoft Excel.
2. Press Ctrl + ` (grave accent). On standard UK and US keyboards, this key is located in the top-left corner directly beneath the Esc key and shares the tilde (~) symbol.

Instantly, Excel widens your columns slightly and reveals every formula (such as =SUM(B2:B10) or =XLOOKUP(A2, D:D, E:E)) in place of the calculated values. To return to the standard numerical display, press Ctrl + ` a second time.

Method 2: Toggle Show Formulas via the Excel Ribbon

If you prefer using the mouse or cannot easily locate the grave accent key on your international keyboard layout:

1. Click the Formulas tab on the Excel ribbon at the top of the window.
2. Look for the Formula Auditing section.
3. Click the Show Formulas button (its icon depicts a cell with fx inside).

When active, the Show Formulas button remains highlighted with a shaded background. Clicking the button again turns the mode off and restores calculated results across the sheet.

Method 3: Configure Excel Options for Specific Worksheets

If you want Excel to consistently display formulas on a particular worksheet whenever the workbook is opened, configure the setting in Excel Options:

1. Click File in the top-left corner and select Options at the bottom of the left sidebar.
2. In the Excel Options window, click Advanced.
3. Scroll down to the section titled Display options for this worksheet.
4. Use the dropdown menu to select the specific sheet you wish to configure.
5. Tick the checkbox labelled Show formulas in cells instead of their calculated results.
6. Click OK to apply your changes.

How to Print Spreadsheets with Formulas Revealed

Financial auditors, educators, and compliance teams frequently need to print worksheets showing the exact formulas used rather than the calculated values. When Show Formulas mode is enabled, Excel automatically respects that view when printing:

1. Activate formula view using Ctrl + ` or the Show Formulas ribbon button.
2. Go to the Page Layout tab on the ribbon.
3. In the Sheet Options group, ensure the Print checkbox under Gridlines and Headings is ticked. Printing row numbers and column letters makes cross-referencing cell coordinates much easier for auditors.
4. Press Ctrl + P to open Print Preview.
5. Notice that the print preview displays the raw formula text alongside column and row headers. Select your printer or choose Print to PDF to generate the documentation.
6. After printing, press Ctrl + ` again to revert your screen back to standard numbers.

Troubleshooting: Why Are Formulas Showing as Plain Text?

If an individual cell displays formula text (like =SUM(A1:A10)) even when Show Formulas mode is turned off, the issue is typically caused by formatting:

• Text Number Format: If the cell was formatted as “Text” before the formula was typed, Excel treats the formula as literal string characters. To fix this, change the cell format to General on the Home tab, click into the formula bar, and press Enter.
• Leading Space or Apostrophe: Check whether an apostrophe (') or space precedes the equals sign. Removing leading characters activates formula parsing immediately.

Using Excel’s Show Formulas feature streamlines workbook validation, accelerates troubleshooting of broken calculation chains, and provides complete visibility into spreadsheet logic.