This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Display Formulas Instead of Their Results

When developing Microsoft Excel 2003 worksheets, you may at times need to debug a series of formulas. This can be difficult since, by default, formula results are shown in the worksheet, not the formulas themselves. However, you can change this by entering a "Formula Auditing Mode". To do this, select "Tools" - "Formula Auditing" - "Formula Auditing Mode".



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Display Formulas Instead of Their Results.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.