Print Option

How can I print out the formulas in an excel spreadsheet- rather than results

2 Answer(s)


Hi Naisy, you can follow below mentioned steps:

1) Open the spreadsheet that you wanted to print.
2) Go to Formulas option on the Ribbon
3) Click on show formulas
4) Take the print out of whatever selection you wanted to print.

Please ensure to again click on show formulas button, so that next time you open the spreadsheet it show results not the formulas.

Hopefully, This has answered your question.


In the Excel sheet that you want to print with formulas, go to Formulas Tab and click on Show Formulas.

You can use the shortcut to view formulas - CTRL + "~"