Excel Show Display Formulas? Toggle & Fix Guide

Yes, Excel can show the formulas in your cells instead of their calculated results. You toggle this view with the keyboard shortcut Ctrl + ` (the grave accent key, usually above the Tab key) or through the Formulas tab by clicking Show Formulas in the Formula Auditing group. This article explains exactly how the feature works, why your spreadsheet might suddenly display formulas, and how to fix common problems.

What “Show Formulas� Actually Does

When you enable Show Formulas, Excel switches from displaying calculated values to displaying the underlying formula text in every cell that contains one. For example, if cell A1 contains =B1+C1 and B1 is 5 and C1 is 10, the cell normally shows 15. With Show Formulas on, it shows =B1+C1.

The feature is a display mode, not a change to your data. It does not alter formulas, formatting, or calculations. It simply changes what you see. It also expands columns automatically because formula text is usually wider than the numeric result. When you turn it off, columns return to their previous widths.

This mode is useful for auditing a spreadsheet, teaching others how a model works, or checking for inconsistent formulas across a range. It is also the easiest way to see all formulas at once without clicking each cell and looking at the formula bar.

How to Turn Show Formulas On and Off

There are three main ways to toggle the display:

• Keyboard shortcut: Press Ctrl + ` (grave accent). On most keyboards, the grave accent key is located to the left of the number 1 key. This works in all modern versions of Excel for Windows. On a Mac, the shortcut is Control + ` (or Cmd + ` in some versions).
• Ribbon button: Go to the Formulas tab, and in the Formula Auditing group, click Show Formulas. The button is highlighted when the mode is active. Click it again to turn it off.
• Excel Options (legacy): In older versions, you could go to File > Options > Advanced and check “Show formulas in cells instead of their calculated results.â€� This still exists in current versions and has the same effect, but the ribbon button is faster.

If you only want to see the formula for a single cell, click the cell and look at the formula bar. To see the formula directly in the cell without switching the whole sheet, you can double-click the cell (if editing is enabled) or press F2.

Why Is Excel Suddenly Showing Formulas?

A common complaint is that a spreadsheet that previously showed numbers now displays formulas everywhere. This usually happens because someone accidentally pressed Ctrl + ` while trying to hit another key, or because the Show Formulas button was clicked unintentionally. It can also occur if you open a file that was saved with the display mode active.

Another cause is that a cell is formatted as Text. If you type a formula into a cell that has Text formatting, Excel treats the entry as a literal string and does not calculate it. The cell will show the formula text, but it will not be preceded by an equals sign in the way you typed it? Actually, it will show exactly what you typed, including the equals sign, but it will not calculate. This is different from Show Formulas mode because the cell is not a real formula; it is text. To fix this, change the cell format to General and re-enter the formula.

If the entire sheet shows formulas, the most likely fix is simply to press Ctrl + ` again. If that does not work, check the ribbon button and the Excel Options setting.

How to Show Formulas for a Single Cell or Range

Sometimes you do not want to switch the whole sheet. You can display the formula text in a separate cell using the FORMULATEXT function. For example, if cell A1 contains =B1+C1, then in cell C1 you could enter:

=FORMULATEXT(A1)

This returns the formula as a text string. It is dynamic, so if you change the formula in A1, the text updates. This is useful for documentation or for creating a formula audit report. The function works in Excel 2013 and later.

You can also use the FORMULATEXT function in combination with other functions, but it only works on a single cell reference, not a range.

Common Problems and Fixes

Problem: Show Formulas is on but nothing appears to change

If your cells contain numbers, not formulas, then Show Formulas will not change the display. The feature only affects cells that contain formulas. If a cell has a hard-coded number like 15, it stays 15.

Problem: Formulas show but do not calculate

This is usually a formatting issue. Select the affected cells, change the number format to General (Home tab > Number Format drop-down), then press F2 and Enter to re-enter the formula. If the cell is in a column that is formatted as Text, you may need to clear the format entirely.

Problem: Printout shows formulas instead of results

If you print the sheet while Show Formulas is active, the printout will show formulas. Turn off Show Formulas before printing. Also check the print settings: In Page Layout > Sheet Options, there is a “Formulas� checkbox under Headings? Actually, that is for row/column headings. The formulas display is controlled only by the Show Formulas toggle.

Problem: The grave accent key does not work

On some non-US keyboard layouts, the grave accent key may be in a different position. Use the ribbon button instead. Alternatively, you can use the Excel Options method.

Show Formulas vs. Trace Precedents

Show Formulas is a static display of all formulas. If you want to understand how a formula gets its data, you might use Trace Precedents (Formulas tab > Formula Auditing). This draws arrows from the formula cell to the cells it references. It is interactive and helps you visualize dependencies.

Another related feature is Evaluate Formula, which steps through the calculation one operation at a time. This is useful for debugging complex formulas. Show Formulas is simpler and shows everything at once, but it does not explain the logic flow.

Frequently Asked Questions

How do I stop Excel from showing formulas in all cells?

Press Ctrl + ` again or go to the Formulas tab and click “Show Formulasâ€� to toggle it off. If that does not work, check File > Options > Advanced and make sure “Show formulas in cells instead of their calculated resultsâ€� is unchecked.

Why does Excel show the formula but not the result?

This usually means the cell is formatted as Text. Select the cell, change the format to General, then press F2 and Enter. If the entire column is Text, you may need to use Text to Columns (Data tab) to convert it, or re-type the formula.

Can I show formulas in only one worksheet?

Yes. Show Formulas is a per-worksheet setting. You can turn it on for one sheet and off for others. The keyboard shortcut and ribbon button affect only the active sheet.

Does Show Formulas affect calculation?

No. Excel still calculates all formulas normally. The display mode only changes what is shown in the cells. Calculations continue to update when you change inputs.

Is there a way to show formulas without the equals sign?

No, the equals sign is part of the formula syntax. Show Formulas displays the exact formula text, which always begins with an equals sign (or a plus/minus if you typed it that way, but Excel adds the equals sign).

Why are my columns so wide when I show formulas?

Excel automatically expands columns to fit the longer formula text. When you turn off Show Formulas, the column widths may not revert automatically. You can manually adjust the widths or use the AutoFit feature (select columns, then double-click the boundary).

Related

• Fix Switch Sports Motion Control & Joy-Con Tracking
• Pixel Buds 2 Audio Cutout Issues: Fixes That Work
• Can LLMs Inspect Their Own Thoughts? Evidence