How to turn off printing cell errors in Excel

In the previous post, we had seen how to print cell comments in Excel and in this tutorial we will be seeing the steps required to turn of the cell errors displayed while printing a Worksheet in Excel 2016, 2013 and 2010.

A worksheet displays different cell errors, for example when you have an invalid expression it displays #NAME? error as shown below.

image

These cell errors by defaults get printed while printing the worksheet. If you do not want these errors to be printed then you can turn off by using the option available as part of Page Setup Settings.

Click the File menu –> Print Menu.

image

Then navigate to the Settings section and click the Page Setup option.

image

In the Page Setup window, click the Sheet tab and navigate to Print section. Set the value for Cell errors as to <blank> then click OK to save the changes. Now whenever you print any worksheet with cell containing errors, the errors will not be displayed in the print out.

In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.