How To Hide Errors In Cells When Printing In Excel

In this tutorial we are going to look at how easy it is to hide errors in cells when you are printing your documents.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

So here I have a data range of 12 months for five individuals. Notice how several have an N/A in the cells:

I want to multiply those values by 95% and insert the results into another data range, like this:

Notice that at each location where there was an N/A in the original data range, i get an error in the corresponding cell. Now, when I go to print that data, it will appear like this:

Excel does provide a method to suppress or hide those errors when you go to print. To do so, in the Print Preview screen, click on the Page Setup link at the bottom left:

You can also click on the dialog box launcher for the Page Setup on the Page Layout tab:

This will bring up the Page Setup dialog box. Go to the last tab called Sheet and you will see an option called “Cell errors as:”. Next to that is a drop down box where you can choose how you want your errors to appear:

You can select:

Select the one that you want, and Excel will display those errors in that fashion. Here I chose “blank”:

And that’s how easy it is to do that in Excel!

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply