Page 378 - Excel 2013 All-in-One For Dummies

360 Removing Errors from the Printout Removing Errors from the Printout
What if you don’t have the time to trap all the potential formula errors or track them down and eliminate them before you have to print out and dis- tribute the spreadsheet? In that case, you may just have to remove the dis- play of all the error values before you print the report.
To do this, click the Sheet tab in the Page Setup dialog box opened by click- ing the Dialog Box launcher on the right side of the Page Setup group on the Page Layout tab. Click the Sheet tab in the Page Setup dialog box and then click the drop-down button attached to the Cell Errors As drop-down list box.
The default value for this drop-down list box is Displayed, meaning that all error values are displayed in the printout exactly as they currently appear in the worksheet. This drop-down list also contains the following items that you can click to remove the display of error values from the printed report:
✦ Click the <blank> option to replace all error values with blank cells.
✦ Click the -- option to replace all error values with two dashes.
✦ Click the #N/A option to replace all error values (except for #N/A entries, of course) with the special #N/A value (which is considered an error value when you select the <blank> or — options).
Blanking out error values or replacing them with dashes or #N/A values has no effect on them in the worksheet itself, only in any printout you make of the worksheet. You need to view the pages in the Print Preview area in the Print screen in the Backstage view (Ctrl+P) before you can see the effect
of selecting an option besides the Displayed option in the Cell Errors As drop-down list box. Also, remember to reset the Cell Errors As option on the Sheet tab of the Page Setup dialog box back to the Displayed option when you want to print a version of the worksheet that shows the error values in all their cells in the worksheet printout.