How to Show All Formulas 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. Treat “show all formulas in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected formula shows up while it is still harmless. 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 turns a calculation you can defend to a CFO or an auditor into a method you can reuse, explain, and defend when the workbook leaves your screen.

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. Here is the takeaway for “show all formulas in excel”: follow the steps at the top, check the result on the sheet itself, and keep undo in mind while you experiment. Done once deliberately, it becomes something you do from memory in Excel rather than something you search for again.

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