Show Formulas in Excel Print: Steps and Fixes

Formulas & functions · Updated November 18, 2026

To show formulas in an Excel printout, turn on Show Formulas for the worksheet, then print it as usual. In Excel for Microsoft 365 on Windows, press Ctrl+` (the grave accent key, usually below Esc), or choose Formulas > Formula Auditing > Show Formulas. Check Print Preview before printing; formula text often needs wider columns or a landscape page to remain readable. Turn Show Formulas off afterward to return the sheet to its normal display.

What You’ll Need

  • An Excel workbook containing formulas. The feature displays formulas in formula cells; cells containing typed values remain unchanged.
  • Access to the worksheet you want to print and, ideally, a printer or a way to save the printout as a PDF.
  • A little room to adjust column widths, page orientation, or scaling if the formulas are longer than the existing cell widths.

Step-by-Step

  1. Open the correct worksheet. Show Formulas applies to the active worksheet, not automatically to every sheet in the workbook. Click the tab for the sheet whose formulas you need to print. If the workbook has several relevant sheets, you will need to enable the view separately on each one you plan to print.
  2. Turn on formula display. On Windows, use Formulas > Formula Auditing > Show Formulas. You can instead press Ctrl+`. The grave accent is not the apostrophe key; it is usually the key just below Esc and to the left of 1 on a US keyboard. If the shortcut is inconvenient on your keyboard, use the ribbon command.
  3. Confirm the worksheet changed. Formula cells should now show their expressions instead of calculated results. For example, a cell that previously displayed a total may now show the calculation typed into it. Ordinary text and numbers that are not formulas still appear as they did before. This is a display setting, not a change to the underlying calculations.
  4. Set the area to print, if needed. If you only need part of the sheet, select the required cell range, then choose Page Layout > Print Area > Set Print Area. This limits the printed area and can keep unrelated data off the page. To print a one-time selection without setting a lasting print area, go to File > Print and choose Print Selection from the settings. Check that the selected range includes every formula and heading you want readers to see.
  5. Make formula text fit. Formula strings are often wider than the calculated values they replace. Widen columns by dragging the boundary between their column letters, or select relevant columns and use Home > Format > AutoFit Column Width. AutoFit can make columns very wide when a formula is long. You can instead widen only key columns, wrap text, or use a smaller font if that produces a clearer page. Keep enough room for the longest expressions.
  6. Check page layout and scaling. Choose Page Layout > Orientation > Landscape if the formula columns run across the page. Set paper size and margins if required. Under File > Print, review the scaling options. Fit All Columns on One Page may help with a wide sheet, but it can shrink text too much; use multiple pages across or down when legibility matters more than fitting everything onto one sheet.
  7. Inspect Print Preview before printing. Choose File > Print and review every page using the preview controls. Confirm that formulas are visible, not clipped at the right edge, and not reduced to unreadable size. Check page breaks, repeated headings, and whether the intended print area is included. If a formula is missing or a column is cut off, return to the sheet and adjust the range, width, orientation, or scaling.
  8. Print or save a PDF, then restore the normal view. When the preview looks right, print the worksheet or choose a PDF printer or PDF save option available on your system. Afterward, turn off Show Formulas with the same ribbon command or shortcut. This restores the usual results view on that sheet; it does not remove or alter the formulas.

Common Mistakes

Printing before enabling Show Formulas: Excel then prints calculated results rather than the expressions. Turn on the setting first and confirm that the cells visibly show formulas on the worksheet before opening Print Preview.

Assuming the shortcut uses an apostrophe: Ctrl+` uses a grave accent, not the straight or curly apostrophe. Keyboard layouts differ, so the ribbon route is a dependable alternative. Also note that a laptop may require a key combination to enter the grave accent.

Expecting the setting to affect every tab: Formula display is controlled per worksheet. Switching to another sheet may show its values unless Show Formulas is enabled there too. Check each sheet individually before printing a multi-sheet workbook.

Using a print setting that shrinks everything: Scaling a wide worksheet to a single page can make formulas too small to read. Preview the result at a realistic size. It is often better to use landscape orientation or more than one page than to force a dense sheet onto one page.

Confusing formula display with a change to the workbook: Show Formulas changes what Excel displays and prints, not the calculations themselves. Do not replace formulas with typed text just to make them appear on paper; doing so can break the workbook’s calculations.

Tips

  • Use a copy for a presentation or audit printout. If you need a specially formatted formula report, save a separate copy first. You can adjust widths, page layout, and print areas in the copy without disturbing the working version.
  • Keep useful identifiers beside the formulas. Include column headings, row labels, or a short description so readers can tell what each expression relates to. Use Page Layout > Print Titles to repeat heading rows or columns on additional printed pages.
  • Consider a dedicated formula-report sheet. For a recurring report, create a separate sheet that organizes the relevant formulas and labels for printing. This can be easier to read than widening a dense working sheet, and it leaves the original layout intact.
  • Use Print Preview as a layout check, not just a final button. Formula visibility on the screen does not guarantee that all characters fit on paper. Preview each page after every major change to column widths or scaling.
  • Know the Mac and web differences. In Excel for Mac, use the Formulas tab and its Show Formulas command; the keyboard shortcut may differ by keyboard layout, so the ribbon is the safest route. In Excel for the web, use the Formulas tab’s Show Formulas command if available, then check the browser’s print preview. Ribbon layout and printing options can vary slightly between desktop and web versions.

Troubleshooting

The cells still show answers after using the shortcut. The key may not have sent a grave accent, or the shortcut may differ on your keyboard. Open Formulas > Formula Auditing and click Show Formulas directly. Make sure the intended sheet is active. If some cells still show numbers, they may contain fixed values rather than formulas.

Formulas show on screen but not in the printout. Reopen File > Print and check the preview. If it shows results, return to the sheet, enable Show Formulas again, and confirm the expressions are displayed before printing. Also verify you are printing the same worksheet, workbook, and selected range that you checked.

Only part of a formula is visible. Increase the column width or use text wrapping, then preview again. If adjacent cells contain content, a long formula cannot simply spill into them. A formula may also be split by a page boundary; adjust the page break or print area, or allow the sheet to use more pages.

The printout is tiny or spans too many pages. In File > Print, review the scaling choice and page orientation. Avoid fitting both the width and height to one page for a large worksheet. Try Landscape, narrower margins, or fitting only the columns to one page while allowing multiple pages down. If that still produces small text, print a smaller area or use additional pages.

The setting seems to turn off when you change sheets. That is expected if formula display has not been enabled on the other sheet. Activate each tab and turn it on separately. For a workbook-wide review, check every sheet that will be included in the print job rather than assuming one toggle covers all tabs.

A formula appears as text or does not calculate. Show Formulas is not the same as entering a formula as text. If a cell continues to show a formula after you turn Show Formulas off, inspect the cell for a leading apostrophe or a Text number format. Those can cause an entry to be treated as text; changing the format and re-entering the formula may be necessary. Make a copy before changing data in an important workbook.

Frequently Asked Questions

Can I print formulas without changing how the worksheet normally looks?
Yes. Enable Show Formulas, print or save the PDF, and then disable Show Formulas. The switch changes the worksheet’s display, not the formula calculations or stored results.

Does Show Formulas apply to the entire workbook?
No. It applies to the active worksheet. Turn it on separately for each sheet whose formulas you want to print, and check each sheet’s preview.

Will cells containing typed numbers also change?
No. The feature reveals formulas in formula cells. Values entered directly into cells remain displayed as values, so a formula printout can contain both expressions and ordinary data.

Can I show formulas in only a few selected cells?
Show Formulas is a worksheet display option, not a selected-cell-only switch. To print just a few formula cells, enable it for the sheet and print a selected range or set a print area around those cells.

Why are some formula characters missing from the printed page?
The column may be too narrow, the print area may cut it off, or scaling may be forcing too much content onto one page. Widen columns, adjust the print area or page layout, and inspect Print Preview again.

Does this work in Excel for Mac and Excel for the web?
Yes, versions with the Show Formulas command can display formulas for printing. On Mac, use the Formulas tab if the keyboard shortcut is unclear. In the web version, the command and print controls may be arranged differently, so confirm the browser’s print preview before printing.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.