Excel Display Formula Instead of Result

What this does

Show Formulas is a per-worksheet view switch: every cell displays its formula text instead of its calculated result, and columns widen to fit. It is the fastest way to audit a sheet, and it is also the accident that produces the most common "Excel is broken" question — someone hits Ctrl+` and every cell suddenly shows =SUM(...). If only *some* cells show their formula, that is a different problem: those cells are formatted as Text, or the entry starts with a leading space or apostrophe. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “excel display formula instead of result”. Start on a copy or a tiny sample, keep the affected formula visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a calculation you can defend to a CFO or an auditor, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

B2 displays =A2*1.2 instead of 24. Press Ctrl+` — if every other formula cell also flips to text, Show Formulas was on and one keystroke fixes it. If only B2 is affected, select it, set Home ▸ Number Format to General, then press F2 and Enter to re-enter the formula. To hide formulas from other people rather than from yourself, select the cells ▸ Ctrl+1 ▸ Protection ▸ tick Hidden, then Review ▸ Protect Sheet. It is both the standard way to audit somebody else's workbook and the answer to the most-asked panic question in Excel, and the two cases are told apart by whether one cell or the whole sheet is affected. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. The short version of “excel display formula instead of result”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

Common mistakes

• Assuming the file is corrupt when a stray Ctrl+` is the entire cause.
• Reformatting a Text-formatted cell to General and expecting it to recalculate on its own — it needs re-entering with F2 then Enter.
• Ticking Hidden in Format Cells and stopping there; nothing is hidden until the sheet is protected.
• Confusing this with Formulas ▸ Calculation Options ▸ Manual, which leaves stale results rather than showing formula text.

Frequently asked questions