How to Print Formulas in Excel

A webiste visitor asked this question in Excel recently: How can I print the formulas that I have used on my Excel worksheet. My boss insists on seeing them. Before you can print the formulas you need to display them. To display all the formulas used on your Excel spreadsheet press ‘ctrl’ + ‘~’ (tilde key) together. The tilde kay is just below the ‘esc’ key on your keyboard.
Another simple way to display the formulas is to click on the ‘Formulas’ tab, select the ‘Formula Auditing’ option and then select the ‘show formulas’ from the menu that pops-down.

Watch the training video below to learn how to print the formulas in MS Excel 2007:

Leave a Reply

Your email address will not be published. Required fields are marked *