Hide Formula Errors While Printing [Quick tip]

Posted on May 27th, 2009 in Excel Howtos , Learn Excel - 1 comment

Here is a quick excel printing tip. Use the page setup options from print preview area of the spreadsheet to select how you want to handle the formula errors when the worksheet is printed (More on errors: understand and fix excel formula errors). You can set it to blank.

hide-errors-while-printing

How to get to the above screen:

  • Excel 2007: Office Button > Print Preview > Page Setup > “Sheet” tab
  • Excel 2003 and before: File > Print Preview > Page Setup > “Sheet” tab

Read more quick tips, they are bite sized and take less than a minute to learn

Written by Chandoo
Tags: , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

One Response to “Hide Formula Errors While Printing [Quick tip]”

Leave a Reply