Show Formulas in Excel: Steps for Windows, Mac, and Web

Formulas & functions · Updated November 18, 2026

To show formulas instead of calculated results in Excel, open the Formulas tab and select Show Formulas in the Formula Auditing group, or press Ctrl+` on Windows. The command toggles the view for the worksheet: it reveals formulas in cells without replacing or changing them. You can switch back to results with the same command.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365. The instructions below focus on Excel for Windows; Mac and web differences are noted where they matter.
  • Permission to edit the workbook is not usually necessary just to change the display, but a protected sheet or restricted file may limit what you can do.
  • If the keyboard shortcut is inconvenient, use the Formulas tab instead. On some keyboards, the backtick key shares a key with another character and may require a different key combination.

Step-by-Step

  1. Open the worksheet you want to inspect. Select its sheet tab at the bottom of the Excel window. Show Formulas applies to the active worksheet, rather than automatically displaying formulas on every sheet in the workbook. If you want to inspect more than one sheet, you will need to turn it on for each one.
  2. Open the Formulas tab. In Excel for Microsoft 365 on Windows, find the ribbon at the top of the workbook and select Formulas. Look for the Formula Auditing group. If the Excel window is narrow, the group or its commands may be collapsed; maximize the window or look for the group’s small menu to reveal its controls.
  3. Turn on Show Formulas. Select Show Formulas in the Formula Auditing group. Cells containing formulas will display their formula text, such as =SUM(B2:B6), instead of the calculated total. A cell containing a typed value such as 25 remains a value; Excel does not convert values into formulas.
  4. Use the shortcut if you prefer the keyboard. Press Ctrl+` on Windows. The backtick is usually on the key near the upper-left corner of the keyboard, often beside the number 1. Press the shortcut again to return to calculated results. If your keyboard layout makes the backtick hard to enter, use the ribbon command instead.
  5. Check that the display changed on the intended sheet. Look at a cell you know contains a formula. The formula should appear in the cell, while the formula bar will still show the cell’s contents when that cell is selected. If you see no change, first confirm that the selected sheet actually contains formulas; blank cells and cells with fixed values have no formula text to reveal.
  6. Make long formulas easier to read. Showing formulas can make columns appear too narrow because formula text is often longer than its result. Drag a column boundary to widen it, or double-click the boundary between column letters to AutoFit that column. You can also select several columns and AutoFit them together. This changes column widths, not formula contents.
  7. Return to the normal results view when finished. Select Formulas > Show Formulas again, or press Ctrl+`. The cells should display their calculated results again. If the workbook will be shared, check the view before saving or sending it so the recipient sees the presentation you intend.
  8. On a Mac, use the ribbon or the Mac shortcut. In Excel for Microsoft 365 for Mac, select Formulas > Show Formulas. The keyboard shortcut is generally Control+`, rather than the Windows Ctrl+` combination. Keyboard layouts vary, so if the shortcut does not work, use the ribbon command. On Excel for the web, look for Show Formulas on the Formulas tab; if it is not available in your current ribbon layout, use the desktop app for this worksheet-wide view.

Common Mistakes

Expecting only the selected cell to change. The Show Formulas command is a worksheet display setting. It does not reveal a formula only in the active cell. To inspect one formula without changing the entire sheet, select that cell and read the formula bar above the grid. You can also click in the formula bar to inspect the expression, but avoid typing or pressing Enter if you do not intend to edit it.

Thinking the command erased results or changed calculations. The displayed formula replaces the visible result temporarily; it does not remove the formula or stop Excel from calculating. Turning Show Formulas off restores the result view. Do not paste over the cells or use Find and Replace to correct a display that only needs toggling.

Forgetting the setting is per worksheet. If one sheet shows formulas and another shows values, that can be expected. Activate each sheet and check its Show Formulas setting separately. Selecting multiple sheet tabs to group sheets is not necessary for ordinary inspection and can make later edits affect multiple sheets at once.

Assuming a formula is missing because the cell looks blank. A blank-looking cell may contain no formula, may contain a formula that returns an empty string, or may have text hidden by formatting or a narrow column. Turn on formula display, select the cell, and inspect the formula bar to distinguish these cases. A formula that returns an empty string still has a formula even though its normal result looks empty.

Confusing formula display with formula-bar visibility. Show Formulas changes what formula cells display inside the grid. The formula bar is a separate area that shows the contents of the selected cell. If the formula bar itself is hidden, enabling Show Formulas does not necessarily make the bar reappear.

Tips

  • Use the formula bar for a quick, one-cell check. If you only need to verify one calculation, select the cell and read the formula bar. This avoids widening columns and changing the view for the whole worksheet.
  • Widen columns before judging what a formula says. Long expressions may be clipped or overlap adjacent populated cells. AutoFit is useful for a quick review, but some long formulas can make columns excessively wide; manually set a practical width afterward if the sheet is hard to navigate.
  • Check formulas in context. A visible expression may refer to cells on another sheet or to named ranges. Read the full formula in the formula bar when the cell display is clipped, and verify that the referenced cells or names are the ones you expect.
  • Keep a clear review copy when needed. If colleagues need to review formulas, consider saving a separate copy with a descriptive filename. This lets you preserve the usual results view in the working file while providing a formula-visible version. Remember that showing formulas is a display choice, not a security feature; it does not protect confidential calculations.
  • Know what the view does not show. Fixed numbers, labels, and other manually entered content remain as entered. Show Formulas is useful for auditing expressions, but it does not list every formula in a workbook or explain whether each result is correct.

Troubleshooting

The shortcut does nothing: Try Formulas > Show Formulas instead. Confirm that Excel has focus and that you are using the backtick key, not an apostrophe. On laptops and international keyboard layouts, the backtick may require a modifier or may be mapped differently. On Mac, try Control+`; using Command instead may not trigger this Excel command.

The formulas are still hard to read: Widen the relevant columns or select the affected columns and use AutoFit by double-clicking a boundary between their column headers. If formula text still appears cut off, select the cell and read the formula bar. A very long expression may not fit comfortably in a worksheet cell even after widening.

Only some cells show formulas: Check whether the other cells contain formulas at all. Cells with typed numbers or text will not turn into formulas. Also check for blank cells and formulas that return an empty string. Selecting a questionable cell and looking at the formula bar is a quick way to see its contents.

The sheet still shows formulas after you expect results: Toggle Show Formulas off from the Formulas tab. If the command appears selected or the worksheet view remains unchanged, click it once and check again. Make sure you are working on the same sheet where you enabled the setting; another sheet can have a different display state.

The formula bar is missing: In Windows, open the View tab and enable Formula Bar in the Show group. This restores the bar above the grid; it is separate from Show Formulas. On Mac, use the View menu or View tab and enable the Formula Bar option available in your Excel version.

You cannot change the view or inspect a cell: Check whether the workbook or worksheet is protected, opened read-only, or in a restricted shared location. You may still be able to view formulas, but some workbook controls can be unavailable. Ask the workbook owner for the required access, or save an authorized working copy before making changes.

Frequently Asked Questions

Does Show Formulas change or overwrite my formulas?
No. It changes how formula cells are displayed on the worksheet. Turn the command off to see calculated results again; the formulas themselves remain in place.

Can I show a formula for just one cell?
Yes. Select the cell and inspect the formula bar. The Show Formulas command, by contrast, changes the display for the active worksheet rather than just the selected cell.

Will Show Formulas reveal formulas on every sheet?
No. Check each worksheet separately. A workbook can have one sheet displaying formula text while another displays calculated results.

Can I print the formulas instead of the results?
Turn on Show Formulas for the relevant sheet, adjust column widths and page layout, then use Print Preview to check the pages before printing. Formula text can make columns much wider and may cause extra pages. Switch the display back when you want to print normal results.

Why does a cell show a formula that starts with an equals sign?
That is the formula text being displayed in the grid. The equals sign marks the beginning of the expression. Turn off Show Formulas to see the calculated result, provided the cell contains a working formula.

Does showing formulas make them visible to other people?
It changes the workbook’s display, but it is not a way to secure or conceal formulas. People with access to the workbook may be able to inspect formulas by selecting cells or using other Excel features. Use appropriate permissions and workbook protection for access control, not the display toggle alone.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.