Excel Howtos, Learn Excel

Hide Formula Errors While Printing [Quick tip]

Last updated on May 27, 2009

Chandoo

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.

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

Share this tip with your colleagues

One Comment
Ask a question or say something...
Tagged under # NA error, errors, Learn Excel, microsoft, Microsoft Excel Formulas, page setup, printing, quick tip, spreadsheets
Category: Excel Howtos, Learn Excel

Want an AWESOME
Excel Class?

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.

Rebekah S

Reporting Analyst

FREE Goodies for you...

How to calculate WEEKNUMBER in Month / Quarter / Year with Excel?

Let’s say you have daily data and your boss wants to see the trends by week in month or week in quarter? How do you calculate the week number in a month or quarter? In this article, let me explain the logic and formulas we can use Excel for this.