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
Leave a Reply
|Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)||Intraday Candlestick Charting [Stock Charts]|