Excel Shows Formula Instead of Value

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. For “excel shows formula instead of value”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. 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. That is what makes a calculation you can defend to a CFO or an auditor useful in real work: repeatable, auditable, and not dependent on memory or luck.

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. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “excel shows formula instead of value”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

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