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

Microsoft Excel 2003 - Printing Spreadsheets - Configure How Cells Containing Errors are Printed

Microsoft Excel 2003 spreadsheets containing functions may show errors, such as:

* Columns may not appear wide enough to hold cell values

* Formulas may look for cells containing only numbers, so if text is instead placed in those cells the formulas will not function.

* A division by zero error may occur

Depending on your needs, cells containing errors may print as shown on the spreadsheet, you can blank out error values, or you can convert all cell errors to "#N/A" or a couple of dashes.

1. Click "File" - "Page Setup".

2. When the "Page Setup" multi-tabbed dialog box appears, click the "Sheet" tab.

3. Underneath "Print" click the "Cell errors as" pull-down. Your choices:

* displayed - print cells with errors as they appear
* <blank> - print a blank cell
* -- - print two dashes
* #N/A - prints "#N/A"

5. Click "OK" to close the dialog box.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 - Printing Spreadsheets - Configure How Cells Containing Errors are Printed.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.