HOW TO: Suppress the Printing of Errors in Workbook Cells in Excel 2002 (288972)

SUMMARY

This step-by-step article describes how to suppress the printing of cell errors in a Microsoft Excel 2002 workbook.

back to the top

How to Suppress Printing of Errors

Excel 2002 provides a way to suppress the printing of errors in cells or to change the format in which they are printed. To accomplish either of these goals, follow these steps:

1. Start Excel 2002, and then open the workbook that you want.
2. On the File menu, click Page Setup.
3. In the Page Setup dialog box, click the Sheet tab.
4. In the Cell errors as list (in the Print area of the Sheet tab), do one of the following:
   • Click <blank> if you do not want cell errors to be printed.
   • Click -- if you want cell errors printed as dashes.
   • Click #N/A if you want cells that contain errors to be printed with #N/A in the cell.
   • Click displayed if you want to print cell errors.
5. Click OK.

back to the top