How to suppress the printing of errors in workbook cells in Excel 2002, Excel 2003 and Excel 2007

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

How to suppress the printing of errors

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

1. Start Excel, and then open the workbook that you want.
2. On the File menu, click Page Setup.
   
   NoteIn Excel 2007, click Page Setup on the Page Layout tab.
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.