How can I see all the formulas in a speadsheet in Microsoft Excel?
Do you find yourself opening an old spreadsheet or a spreadsheet created by someone else? You look at the document and can't figure out what is data and what the formulas that are being used?
Microsoft Excel provides a simple way for you to view all the formulas in your excel document. Once you open the document, just click on the "formulas" tab and click on "Show Formulas" button (see example below). This will display all the formulas that are being used on the spreadsheet. Just click the "Show Formulas" button again and the document will go back to normal.