Excel error values show up with a hash symbol followed by the type of error, e.g. #DIV/0! or #N/A.
When printing, these errors print by default, however you can choose to have Excel not print the error values.
Display the Page Setup (dialogue box). From the Sheet (tab), use the Cell Errors As (drop down box) to specify how error values print.
- displayed – prints the error values as they show in the worksheet.
- <blank> – replaces the error value with a blank; effectively hiding error values.
- – – replaces the error value with two dashes.
- #N/A – replaces all error values with #N/A.
