Excel can print formulas by turning on Show Formulas, setting page layout, then printing the worksheet view.
Printing formulas in Excel is handy when you need to audit a workbook, teach a class, document a model, or hand a file to someone who needs to see the logic behind each result. The trick is simple: make the formulas visible on the sheet before printing. Excel prints what the worksheet view shows, so the printed page can show formulas instead of calculated answers.
The main catch is space. Formulas are often longer than their results, so columns widen and pages can spill sideways. A clean printout needs three moves: switch on formula view, prepare the page, then preview before you print. Do that, and your worksheet becomes a clear map of the math behind the cells.
How To Print Formulas In Excel Without Cell Results
Use the Show Formulas command before printing. In the desktop version of Excel, open the worksheet, go to the Formulas tab, and select Show Formulas. You can also press Ctrl + ` on Windows. The grave accent mark usually sits above Tab on a standard keyboard.
Once formulas appear in the cells, go to File > Print. Check the preview. If the sheet is too wide, change the orientation for a wide page, reduce margins, or scale the sheet to fit one page wide.
Use These Steps For A Clean Formula Printout
- Open the worksheet you want to print.
- Select the worksheet tab if your workbook has many sheets.
- Choose Formulas > Show Formulas.
- Widen columns where formulas get cut off.
- Go to Page Layout and set the page to a wider orientation if needed.
- Choose File > Print.
- Scan the preview for cut text, extra blank pages, and tiny scaling.
- Print only when the preview matches what you want on paper or PDF.
If the printout is for review, print to PDF first. A PDF lets you catch awkward page breaks before wasting paper. It also gives you a shareable record of the formulas as they appeared at that moment.
Why Formula Printouts Often Look Messy
Excel stores a formula in the cell, but the normal worksheet view shows the answer. When you turn on formula view, each cell displays the full expression. A short answer such as 42 may turn into =SUM(B2:B18)-C4, and that longer text needs more width.
That change can stretch the sheet across more pages. Long formulas, nested IF logic, named ranges, structured table references, and copied formulas with full sheet references can all make a printout wider than expected. The fix is not to rewrite every formula. Fix the page setup instead.
Set The Page Before You Print
After formula view is on, use the Page Layout tab. Set margins to narrow when the sheet needs a little more room. Use wide-page orientation for wide workbooks. Microsoft’s Show and print formulas page states the same core method for switching formula view on before printing. If the worksheet still spills across many pages, set scaling to one page wide and let Excel decide the page height.
Microsoft’s print a worksheet or workbook page explains workbook printing choices, including printing a whole workbook, a sheet, or a selected range. That matters when you only want the formula area instead of every tab in the file.
| Print Issue | Likely Cause | Best Fix |
|---|---|---|
| Formulas run off the page | Columns are too narrow for formula text | Widen columns or switch to a wide page |
| Many blank pages print | Used range includes old formatting or far-right cells | Set a print area around the real data |
| Text is too small | Scaling is squeezing too many columns | Fit one page wide, not one page total |
| Formulas are hidden | Show Formulas is turned off | Turn on Show Formulas from the Formulas tab |
| Gridlines are missing | Gridline printing is not selected | Use Page Layout and select Print under Gridlines |
| Column letters are missing | Headings are not set to print | Select Print under Headings on Page Layout |
| Wrong sheet prints | Another tab or workbook section is selected | Click the target sheet, then check Print Active Sheets |
| Formula text is clipped | Rows or columns are fixed too tight | AutoFit columns and raise row height where needed |
Make The Worksheet Easier To Read On Paper
A formula printout should help someone trace logic without opening the workbook. Add row and column headings to the printout when cell references matter. This makes it easier to connect =B4*C4 to the cells on the page.
Gridlines can help too. Go to Page Layout, then select Print under Gridlines. If you use borders already, gridlines may not be needed. Use one or the other so the page stays clean.
Use Print Area For Formula Sections
For large workbooks, don’t print the whole sheet. Select the range with formulas, then choose Page Layout > Print Area > Set Print Area. This keeps the printout tight and prevents random empty columns from showing up.
If you need both formulas and results, make two PDFs: one with Show Formulas on and one with it off. Name the files clearly, such as Budget_Formulas.pdf and Budget_Results.pdf. That pair is easier to review than one crowded printout.
Print Formulas With Helpful Labels
Formula pages are easier to read when the worksheet has clear labels. A cell showing =SUM(D5:D16) means more when the row and column headings say what D5:D16 contains. Before printing, scan the area and add short labels where the logic would feel vague on paper.
Use comments or notes only when they add real clarity. Long comments can clutter the printout, so keep worksheet labels in nearby cells when possible. If a formula is hidden in a protected file, Microsoft’s display or hide formulas page states how formula visibility can be controlled. If a formula is tricky, a small label such as Tax rate source or Monthly total can save the reader from guessing.
| Need | Setting To Use | Why It Helps |
|---|---|---|
| Show formulas | Formulas > Show Formulas | Prints cell logic instead of answers |
| Keep references visible | Page Layout > Headings > Print | Adds row numbers and column letters |
| Keep cells separated | Page Layout > Gridlines > Print | Makes long formulas easier to follow |
| Limit printed area | Page Layout > Print Area | Removes unused cells from the output |
| Share without paper | Print to PDF | Creates a review copy with the same view |
When Formulas Still Won’t Print Correctly
If formulas still do not appear, check whether you are using Excel for the web. In some web versions, cells may show results while the formula appears in the formula bar, so a standard print may not show every formula in the grid. The desktop app is the safer choice for formula printouts.
Protected sheets can also affect what you see. If a formula is hidden on a protected sheet, you may need permission to change that setting. Ask the workbook owner before changing protection settings, since locked cells may be there to guard the file from accidental edits.
Check These Before Sending The File
- Turn Show Formulas off again after printing if you need the normal view back.
- Save a copy before changing print areas in a shared workbook.
- Print to PDF and inspect every page before sending it to someone else.
- Remove private sheets or hidden tabs if the PDF will leave your team.
Best Format For Audits, Classes, And Hand-Offs
For audits, print formulas with headings, gridlines, and a narrow print area. For classes, use fewer columns per page and larger scaling so students can read formulas from a handout. For hand-offs, create a PDF and pair it with the original workbook.
The cleanest formula printout is not the one with the most cells. It is the one that lets a reader trace each calculation without guessing. Turn on formula view, shape the page, preview the result, then print or save the PDF. That small routine makes Excel’s hidden logic visible and much easier to trust.
References & Sources
- Microsoft.“Show and print formulas.”States how to switch worksheet cells from results to formulas before printing.
- Microsoft.“Print a worksheet or workbook.”States print choices for worksheets, workbooks, and selected ranges.
- Microsoft.“Display or hide formulas.”States formula display options and hidden-formula behavior on protected sheets.