How to Print Formulas in Excel 2010

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.

 

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.

Share this...Share on FacebookTweet about this on TwitterShare on Google+Pin on PinterestShare on TumblrShare on RedditEmail this to someone