Hide Formula Errors While Printing [Quick tip]

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

Posts & Navigation Have an Excel Question? « Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them) Intraday Candlestick Charting [Stock Charts] » Go Back to Home Page Tags: # NA error, errors, Learn Excel, microsoft, Microsoft Excel Formulas, page setup, printing, quick tip, spreadsheets

Comments

RSS feed for comments on this post. TrackBack URI

Leave a comment

If you have a question, please ask in the forums