See all How-To Articles

How to Display & Print Formulas – Excel & Google Sheets

This tutorial demonstrates how to display and print formulas in Excel and Google Sheets.

 

display print formulas 3

 

Display and Print Formulas

In Excel, it’s possible to print formulas instead of their results. You can achieve this either by turning on the Show formulas option or using the FORMULATEXT Function. Say that you have the SUM function in column D, summarizing values from columns B and C.

 

display print formulas initial data

 

To print formulas, follow the next, steps.

1. To display formulas first, in the Ribbon go to Formulas > Show Formulas (or use the keyboard shortcut CTRL + ~).

 

display print formulas 1

 

2. Now all formulas in the workbook are displayed as text. To print, first, in the Ribbon go to File > Print (or use the keyboard shortcut CTRL + P).

 

display print formulas 2

 

As a result, all formulas will be printed as text, as you can see in the print preview.

 

display print formulas 3

 

Display and Print Formulas in Google Sheets

To display and print all formulas in Google Sheets, follow the next steps.

1. To display formulas, in the menu, go to View > Show > Formulas (or use the keyboard shortcut CTRL + ~).

 

google sheets display print formulas 1

 

2. In the menu, go to File > Print (or use the keyboard shortcut CTRL + P).

 

google sheets display print formulas 2

 

In the print preview, you can see that, instead of results, there are formulas displayed as text.

 

google sheets display print formulas 3