Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 - Printing Spreadsheets

Configure How Cells Containing Errors are Printed

Summary: In a Microsoft Excel 2003 spreadsheet, how should cells containing logical or mathematical errors be 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.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 - Printing Spreadsheets page.

Print this tip.

- Subscribe!

Search the Site: