FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

December 15, 2015

TheExcelAddict.com Quote of the Day
"How far you go in life depends on your being tender with the young,
compassionate with the aged, sympathetic with the striving,
and tolerant with the weak…
because in your life you will have been all of these."
-- George Washington Carver --



Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)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)
Email: 
fhayes[AT]TheExcelAddict.com
g



If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

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.

Errors Displayed In Worksheet in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
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.

Prevent Errors From Printing in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365
This will not affect how the errors are displayed in your worksheet...only how they are printed.

Printed Report With Errors Supressed in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to thi spage
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630