PDF download Download Article
An easy-to-follow guide so you can have Excel list the formulas used in the sheet
PDF download Download Article

When you add formulas to your Excel spreadsheet, they are hidden when printing and viewing the sheet. If you'd rather show the formulas on your sheet instead of the formula results, you can toggle them on. If you just need to show a single formula on your sheet, you can add a special character to the front of it.

Things You Should Know

  • Press "Ctrl + ~" to see all the formulas, then print it.
  • Alternatively, go to "Formulas > Show Formulas".
  • You can also double-click a cell and enter "`" in front of the formula to make it show up.
Method 1
Method 1 of 3:

Using Keyboard Shortcuts

PDF download Download Article
  1. Launch Excel and open the workbook. You can select the workbook when you start up Excel, or double-click the workbook file to open it directly.
  2. Ctrl+` to show all formulas. The ` key can typically be found to the left of the 1 key, though it may not be present on some laptops.[1]
    • This keyboard shortcut is the same for both Windows and Mac versions of Excel. If you can't find the key, see the next section instead.
    • This will switch each cell with a formula to display the formula instead of the value. You cannot show the formula and the value in the same cell.
    Advertisement
  3. With your formulas displayed, you can print the spreadsheet just like you normally would.
    • You can find the Print button on your Home tab, or in the File menu.
    • You can also press Ctrl+P (Windows) or Command+P (Mac) to open the Print window.
  4. Ctrl+` again. This will toggle all of the formula cells back to the formula results.
  5. Advertisement
Method 2
Method 2 of 3:

Using the "Show Formulas" Button

PDF download Download Article
  1. You'll find this tab in all versions of Excel since 2007, for both Windows and Mac.
  2. This will switch all formula cells to display the formulas instead of the results.
    • If you're using a Mac, click "Show" and then "Show Formulas."
    • You cannot show both the formula and the result in the same cell at the same time.
  3. Once your formulas are appearing in their cells, you can print your spreadsheet and they will be printed instead of the results.
    • You'll find the Print option in the Home tab or File menu, or you can press Ctrl+P (Windows) or Command+P (Mac).
  4. Clicking the "Show Formulas" button again will switch your spreadsheet back to showing the formula results in each cell.
  5. Advertisement
Method 3
Method 3 of 3:

Showing a Single Formula

PDF download Download Article
  1. The "Show Formula" option affects all of the cells in your sheet. There's no toggle for showing a single cell, but you can use a common workaround. Double-click the formula cell so that you can edit it.
  2. You'll be adding a character to the front of the formula so that it stays visible.
  3. ' character to the front of the formula. This character will prevent the formula from running and showing the results.[2]
  4. Enter/ Return. This will add the character and show the formula. The ' that you added will automatically be hidden, so that you'll just see the single formula in the cell.
  5. Once you've displayed all of the formulas you want to, you can print the document as normal.
    • The Print option can be found in the Home tab or File menu. You can also press Ctrl+P (Windows) or Command+P (Mac).
  6. ' from the front of the formula to show results. When you're ready to revert the formula cell to show the results again, double-click it and delete the ' character from the front. When you press Enter/ Return, the formula results will be displayed again.
  7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I print formulas and results in Excel?
    Community Answer
    Community Answer
    Go to the formulas tab on the top bar. Click, "show formulas," click, "file," and then click, "print."
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement

Tips

  • When you show the formulas, Excel will automatically widen the cells to show you the entire formula onscreen.
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement

You Might Also Like

Print Part of an Excel Spreadsheet Print Part of an Excel Spreadsheet
Add Header Row in ExcelAdd Header Row in Excel: Freezing, Printing, Tables, Power Query
Add Autonumber in Excel2 Easy Ways to Add Auto-Numbering in Microsoft Excel
Type Formulas in Microsoft ExcelType Formulas in Microsoft Excel
Make a Spreadsheet in ExcelMake a Spreadsheet in Excel
Merge Cells in Excel Merge Cells in Microsoft Excel: A Quick Guide
Unprotect an Excel SheetUnprotect an Excel Sheet
Unhide All Rows and Columns in Microsoft Excel
Use If‐Else in Excel Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
Insert Pictures in Excel That Automatically Size to Fit Cells Insert Pictures in Excel That Automatically Size to Fit Cells
Create a Mortgage Calculator With Microsoft ExcelCreate a Mortgage Calculator With Microsoft Excel
Create a Graph in Excel Create a Graph in Excel
Unhide Columns in Excel Show Hidden Columns in Microsoft Excel & Unhide Column A
Ethernet Doesn't Have a Valid IP Configuration Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
Advertisement

About This Article

CB
Co-authored by:
Tech Enthusiast
This article was co-authored by Christopher Batchelor. Christopher Batchelor is a wikiHow community member and technology enthusiast. He has experience using a range of different platforms and software, and likes to keep up with updates and new features. This article has been viewed 173,464 times.
How helpful is this?
Co-authors: 5
Updated: October 7, 2024
Views: 173,464
Categories: Microsoft Excel
Thanks to all authors for creating a page that has been read 173,464 times.

Reader Success Stories

  • PL K.

    PL K.

    Jul 17, 2017

    "This gave me 3 very simple and useful options to my question that the "tell me what you want to do"..." more
    Rated this article:
Share your story

Is this article up to date?

Advertisement