How to Print Formulas in Excel 2010

Last updated: March 26, 2019

Formulas are a very important part of the Excel 2010 user experience, because they allow you to automate calculations that need to be performed upon values in Excel. And while the result of those formulas’ calculations is typically the most important part of the equation, you may find yourself in a situation where you need to know how to print formulas in Excel 2010.

The method for doing so is not very obvious, but it does exist. By following the steps in the tutorial below you will be able to view and print out the formulas that are contained within a cell, as opposed to the calculated value resulting from the formula.

How to Print Formulas in Excel – Quick Summary

  1. Select the Formulas tab at the top of the window.
  2. Click the Show Formulas button.
  3. Choose the File tab at the top-left of the window.
  4. Select the Print tab at the left side of the window.
  5. Click the Print button.

For additional information and pictures of these steps, continue to the section below.

Show and Print Excel 2010 Formulas

There are many different kinds of Excel formulas, and they can be inserted easily as pre-configured formulas, or as formulas that you create yourself. Regardless of their origin, you can change your Excel settings to allow the formulas to be displayed on your screen or when you are printing.

Step 1: Open the Excel file containing the formulas that you want to print.

Step 2: Click the Formulas tab at the top of the window.

the formulas ribbon tab in excel 2010

Step 3: Click the Show Formulas button in the Formula Auditing section of the ribbon at the top of the window.

how to print formulas in Excel 2010

Step 4: Click the File tab at the top-left corner of the window, then click the Print option in the column at the left side of the window. Note that you can also press Ctrl + P on your keyboard to quickly access the Print menu as well.

Step 5: Click the Print button to print the document.

Once the document has been printed with the displayed formulas, you can return to the location identified in Step 3 and click the Show Formulas button again to stop displaying your formulas.

Are you finding that your formulas aren’t updating when you change a value that should change a formula result? Find out how to force Excel to calculate your formulas by enabling an automatic calculation option. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.