Welcome to the online edition of "Spreadsheet Tips From An Excel Addict".

Due to the prevalance of email filters and spam filters all over the Internet, in addition to blocking junk mail, these filters may also be inadvertently blocking a lot of your legitimate email, such as my newsletter.

I have discovered that some people who subscribed to my newsletter, to learn my time-saving spreadsheet tips and shortcuts, haven't been receiving them regularly. Some aren't receiving them at all. This is due to email filters. I can assure you that I have been faithfully writing and publishing this newsletter every week.

To ensure that you will always have access to my Excel tips and shortcuts, in addition to my newsletter being sent by email each week, I will also be publishing an online version that contains the same tips, tricks and shortcuts to help you get your work done faster and with less frustration. Once my email version of the newsletter has been sent out, I will be sending a quick follow-up email containing a special link to the online version.

This short follow-up email will be less prone to being blocked by the filters so, if the email version of my newsletter doesn't make it through to your inbox, you will be able to click the link in the second email to access this online version.

My goal is to share all my tips and shortcuts with you and help you benefit from Excel's amazing capabilities. If that requires publishing an email version and an online version, that's what I'll do.

You can help me share this valuable information with others by recommending my newsletter to your friends and associates who use Excel. You can click here to send an email to your friends and associates right now.

I'd really appreciate hearing from you about your experience with receiving my newsletters. Just drop me a line at francis@TheExcelAddict.com.

To Your Success!
Francis Hayes (The Excel Addict)

Insert New Sheets Fast
If you've been using the Insert, Worksheet menu commands to insert new worksheets in your workbooks, here's an even faster way. Just press Alt+F11 and a new worksheet will be added before the current sheet.

Then send me an email explaining what it is. I will personally review every entry and select the one that I think could get "the biggest bang for the buck" with a solution from The Excel Addict. One lucky person will get a custom solution to their Excel problem just for being a loyal reader of my newsletter. The best part about this is, it won't cost you a BUCK and you'll get the BANG absolutely FREE. This could possibly save you hundreds of hours every year.

Submit your suggestions to BigBang@TheExcelAddict.com

If you subscribed to this newsletter prior to this current month, you can still get your name in for the draw each month by helping me share this newsletter.

All you have to do each month is click here to recommend my newsletter and website to a friend. For each person that you refer, your name will go into the draw. The more Excel friends you refer, the more chances you have of winning a t-shirt. But please, recommend it only to people you know and who are Microsoft Excel users.

If you enter 1/2 in a cell, Excel will interpret this as a date and automatically format the cell as a date. To enter a fraction that Excel can recognize, you have to precede your fraction with a zero and a space, for example 0 1/2. Excel will now recognize this entry as a fraction, store it's decimal equivalent in the cell and format it to display as a Fraction.

How To Avoid #DIV/0! Errors
One of the most common questions I’m asked in Excel is how to deal with #DIV/0! errors. It's common to get #DIV/0! errors in worksheets that contain formulas with division operations. This error results from the divisor part of a division formula referring to a cell that is blank or has a zero value.

There is no perfect solution for this problem. Most times you'll want to know that a formula is trying to divide a number by zero, but there may be times where you want to suppress this error for reporting purposes.

You can modify your formula to display either a blank or a zero whenever the formula results in an error. Use one of these formulas:

=IF(ISERROR(formula),"",formula) or
=IF(ISERROR(formula),0,formula)

Just substitute your original formula for the word formula.

Keep in mind that, technically, a 'blank' or 'zero' answer is incorrect. You cannot divide a number by zero. Use this with caution.

TESTIMONIALS: Please drop me a line at kudos@TheExcelAddict.com and let me know how my Tips, Tricks, Shortcuts, and Techniques have helped you.

COOL STUFF: Do YOU know of some "out-of-the-ordinary" really cool thing that YOU can do in Excel? Share it with me and I may publish it in a new section coming to my website called "Cool Stuff You Can Do With Excel". Send your suggestions to coolstuff@TheExcelAddict.com

OTHER COMMENTS: If you have any other comments or suggestions, please don't hesitate to let me know at francis@TheExcelAddict.com

There are tens of millions of other Microsoft Excel users all over the world. The vast majority of them have a very limited knowledge of Excel's capabilities. My goal is to share this information with everyone I possibly can and help them to benefit from Excel's amazing capabilities.

Please help me spread the word about my newsletter. If you know other Excel users, please tell them about "Spreadsheet Tips From An Excel Addict". I'm sure they'll appreciate it.

VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter.

1. You could minimize them one by one, as most users do.
2. You could right-click on the Taskbar and choose Minimize All Windows.
3. You could press the Windows key (if your keyboard has one) plus the 'M' key.
4. Or you could click on the small Show Desktop button on your Quick Launch toolbar in your Taskbar.

Which one is your favorite? I have two. I always like to have a keyboard shortcut AND a mouse shortcut for almost everything I do in Windows.