Excel formulas print instead of results — calc mode & cell format

Joe B.

Reviewed for technical accuracy

Specialities: Excel & Office, Windows 11/10, Printers, PDF export, Business reporting

Excel formulas printing instead of results — Show Formulas, calc mode, and cell format Text fixes

Technician

Hey! Let’s fix why your Excel formulas print instead of results when you send a sheet to the printer or PDF.
A few questions so we can target the right setting: when you look at the worksheet, do you see normal numbers or the full =SUM(A1:A10)-style formulas showing instead of values? Are you printing straight from Excel, or first saving as PDF? And is this on Windows or Mac, and which version of Excel (Microsoft 365, Excel 2019, etc.)?

Customer

I’m on Excel for Microsoft 365 on Windows. On screen I see formulas in the cells, not the results. When I print or save as PDF, it also prints the full formulas. I just want the calculated values to show and print, not all the =IF() stuff.

Technician

Got it — classic case of Excel being in a “show formulas” or Text format mode.
Excel can deliberately display and print formulas instead of results in two main ways:
1) The sheet is in Show Formulas view (Formulas → Show Formulas or the Ctrl+` shortcut). This makes every cell show the formula and will also print formulas instead of values.
2) The cells are formatted as Text or have a leading apostrophe or space, so Excel treats the formula as plain text instead of calculating it.
We’ll turn off formula view, fix cell format, and then check calculation mode (Automatic vs Manual) so your workbook calculates and prints correctly.

Customer

Okay. I might have hit some shortcut by mistake. How do I check if that Show Formulas thing is causing Excel to show formulas instead of results when I print?

Technician

Step 1 — Turn off Show Formulas so values display and print
1) Open the affected worksheet and go to the Formulas tab on the ribbon.
2) Look in the Formula Auditing group for the Show Formulas button. If it’s highlighted, click it once to turn it off.
3) Shortcut way: press Ctrl+` (grave accent, usually above Tab). That toggles between formulas view and normal results view for the sheet.
Once Show Formulas is off, each cell should switch from =A1+B1 to its numeric result. When you print or export to PDF now, Excel will print values instead of formulas.

Customer

That helped on one sheet, but I still have some cells where the formula shows as text even with Show Formulas off. They start with =SUM but Excel isn’t calculating them. They also print as the literal formula.

Technician

Step 2 — Fix cell format “Text” and hidden characters
When Excel formulas show instead of results in just some cells, it’s usually formatting:
• Select the problem cells and press Ctrl+1 → Number tab. If they’re set to Text, change the format to General or Number.
• After changing the format, press F2 then Enter on each formula (or fill down) so Excel re-evaluates it.
• Check that there’s no space or apostrophe before the = sign in the formula bar. A leading ' or space forces Excel to treat it as a text string, which then prints exactly as typed.
Once the cells are “General” and the = is the very first character, formulas should calculate and print as values.

Customer

I see — most of those cells were formatted as Text. I changed them and they calculate now. But one of our shared workbooks still sometimes prints old numbers until we hit F9. Is that a calculation mode thing?

Technician

Exactly — that’s the calculation mode side of the problem.
Step 3 — Set Excel calculation to Automatic so printed results are up to date
1) In Excel, go to Formulas → Calculation Options.
2) Make sure Automatic is selected. If it’s set to Manual, Excel won’t recalc formulas until you press F9, which means you can print stale results.
3) For heavy models you can leave Manual on, but always press F9 (recalculate workbook) or Shift+F9 (active sheet) before printing or exporting to PDF.
Once Automatic is on or you’ve recalculated, the sheet will show current values and your printer will no longer output outdated figures or formulas.

Customer

Good to know. We also have one template where management wants to “see formulas” in one view and normal results in another. Is there a clean way to show and print formulas on purpose without messing up the whole workbook?

Technician

Sure — if you ever want an Excel printout of formulas instead of results, do it in a controlled way:
• Create a copy of the sheet (right-click tab → Move or Copy → “Create a copy”) and turn on Formulas → Show Formulas just on that copy. Print that sheet for audit and keep the original for normal printing.
• Or, create a dedicated “Formula Map” sheet that uses text copies of the formulas (via FORMULATEXT in newer Excel versions) so you can print formulas without touching the original layout.
That way you keep one sheet optimized for clean printed results, and one for documentation.

Customer

Makes sense. One last thing: some pages still cut off formulas or look weird when we print. Is that page layout or print settings, or is it still a formula issue?

Technician

That part’s layout, not calculation — but it still affects how people perceive the data.
Step 4 — Tidy print layout so values and formulas fit the page
• Go to Page Layout → Orientation and choose Landscape for wide reports.
• Use Page Layout → Scale to Fit to fit all columns on one page if needed, or set a custom scaling like 90–100% so printed values stay readable.
• In File → Print, check the preview to be sure the cells you fixed (now showing results) actually fit on the page before you send a big batch to the printer.
Once the workbook is calculating correctly and the print area plus scaling are set, you’ll get consistent output every time.

Customer

After turning off Show Formulas, changing Text cells to General, and switching back to Automatic calculation, my printouts finally show the numbers instead of formulas. Anything else I should double-check before giving this to the rest of the team?

Technician

Final checks before you roll it out:
• Press Ctrl+` once to confirm Show Formulas is off, and save the file in that state.
• Spot-check key columns for cells still formatted as Text; convert them to General and re-enter formulas as needed.
• In a shared environment, confirm calculation mode is Automatic on a test machine and that nobody’s macro is forcing Manual mode behind the scenes.
If everything looks right on screen and in Print Preview, you’re good — Excel will print results instead of raw formulas going forward.

Customer

Perfect — exactly what I needed. The sheet now shows and prints the correct values. Thanks!

Technician

Summary: To fix Excel formulas printing instead of results, turn off Show Formulas, change any Text-formatted formula cells back to General/Number, remove leading apostrophes or spaces, and set Calculation Options → Automatic so everything recalculates before print. After that, your workbooks will show and print values instead of raw formulas. Want me to walk through your actual file and printer setup live? Open the chat.

Quick answer: the accepted fix

Accepted fix when Excel formulas print instead of results: toggle off Show Formulas (Formulas → Show Formulas or Ctrl+`), change any Text-formatted formula cells back to General or Number and re-confirm the formula, remove leading apostrophes or spaces, and set calculation mode to Automatic so the sheet recalculates before printing or exporting to PDF.

FAQ

Step-by-step: fix Excel formulas printing as text (Windows)

1. Open the workbook and press Ctrl+` or use Formulas → Show Formulas to make sure formulas view is off.
2. Select cells where formulas appear as text, set the format to General in Format Cells, and re-confirm the formula with F2 → Enter.
3. Check Formulas → Calculation Options and switch to Automatic so results update before printing.
4. Use File → Print to preview and confirm that the sheet now shows and will print values instead of formulas.

Note for Excel on macOS

1. On Mac, use Formulas → Show Formulas or the same Ctrl+` (or ⌘+`, depending on layout) shortcut to toggle formulas view off before printing.
2. In Excel → Preferences → Calculation, confirm the workbook is set to Automatic, then check that Text formats and leading apostrophes have been removed from formula cells.

Sources

• Microsoft — Display or hide formulas
• Microsoft — Show and print formulas
• Ablebits — Excel formulas not working, not updating, not calculating

Matt ● replies in < 1 min

Technician Expert

⭐⭐⭐⭐⭐ Trusted by 27,000+ customers

Alex · Expert's Assistant

Start Chat

5 Tech Support Specialists are online right now.