Hide Formula Bar 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 “hide formula bar 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. 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. If you take one thing from this page on “hide formula bar in excel”, 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