Hide Cell error while printing

If you want to hide the error while printing your spreadsheet, There is a simple print setting change you need to do.

Follow the below steps:-
1) Go to Page Setup
2) Select Sheet tab
3) Select blank or "--" in "cell error as:" option.
4) click Ok and print the page


This will keep the error in spreadsheet but will not be displayed on printed pages.

Sometimes it’s useful to know where the errors are so you can correct any that are not expected, but if you regularly print reports you probably don’t want the errors displayed.

Do give a try when next time you print any spreadsheet.