How do I Print all the formulas in my excel spreadsheet?
Do you want to print all the Formulas in one of your Excel spreadsheets so you can have the hard copy right beside you while you work? Well...here's the steps to do this easily.
1. Hit ctrl+` (tile) to show all your formulas.
2. Go to the Edit menu and select "Go To".
3. In the Go To box, click on the button that says Special.
4. In the Special box, put a check in Formulas.
5. Now all your formulas are selected, so go to the File menu and choose Print and in the section where it says "Print What", choose Selection.
ALSO...if you want to see the exact locations of the formulas, before you do this, go to the File menu and choose Page Setup - Sheet Tab and put a check in the boxes that say "Gridlines" and "Row & column headings" in the Print section. This way, you won't just see the formulas spread out all over your pages, but you will see the rows and columns where they are located.