December 15, 2015
Hi fellow Excel Addict,
Thanks for taking a few minutes to join me today for another time-saving Excel tip to add to your current set of Excel skills.
Some tips may save you a significant amount of time and others may save you only a few seconds, but as you learn more and more of them, it can make a big difference to your productivity over time. And I've got hundreds more tips to share with you.
Take Dr. Seuss's advice... "The more that you read, the more things you will know. The more that you learn, the more places you'll go."
Take care and keep Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
How to Prevent Errors from Printing
It's not uncommon to see spreadsheets with errors such as #DIV/0 or #N/A. Not such a big deal as long as you know your formulas are correct, but these error often clutter up a printed report.
If you're OK with these errors in your worksheet but don't want them to print, rather than going through the trouble of hiding these errors, there is an easy way to prevent them from printing.
1) From the Page Layout tab, click the small 'dialog launcher' arrow on the bottom right corner of the Page Setup group. This will open the Page Setup dialog;
2) Click the Sheet tab and from the 'Cell errors as' dropdown, choose whether to print these cell errors as (1) as they are displayed on the worksheet, (2) blanks, (3) two dashes or (4) #N/A;
3) Click OK.
This will not affect how the errors are displayed in your worksheet...only how they are printed.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630