How to Audit Formulas in Excel 2007

1. Open an existing Microsoft Excel document to audit. Double click on the 'My computer' icon on the operating system desktop. Then locate the existing Excel document and double click on that file.
2. Select the 'Microsoft Office Main Menu Button' located in the top right hand corner of Microsoft Excel. From that menu click on the 'Excel Options' button located at the bottom of the menu dialogue box.
3. Click on the 'Advanced' options button on the Excel options dialogue box.
4. Check all the options under the 'Display Options for This Workbook' section. Also, make sure that the 'For Object: Show' option choose 'All.'
5. Show all the formulas in an Excel worksheet by selecting all the cells. Do this by clicking on the top left hand corner of the worksheet. Once they are all selected click on the 'Formulas' tab and choose 'Show All Formulas' from the formula auditing section of the formulas tab.
6. Audit the formulas by choosing the 'Error Checking' button in the formula auditing section of formula ribbon. A user can also trace dependents and precedents by choosing the 'Trace Dependents' and 'Trace Precedents' option from the very same section of the formula auditing section of the formulas ribbon.