View Formula Version in Excel

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. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “view formula version in excel”, 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 workspace setting that makes a big sheet comfortable to navigate 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. A practical tip: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.

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. Treat “view formula version in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

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