Hi Fellow Excel Addict,

Welcome to another edition of 'Spreadsheet Tips From An Excel Addict.' We are still having unseasonably warm temperatures here on the east coast of Canada. Unfortunately our neighbors in Nova Scotia bore the brunt of Hurricane Juan last week and are still recovering. I hope you are faring much better.

Are you a soccer (football) fan? As a proud Canadian I will be cheering on our Canadian women's team tonight in World Cup action against China. I'm sure my subscribers from China will have a different cheer. Hopefully it will be a great game.

Are you are making good progress in expanding your Excel skills? If there is something you would like to see in a future issue of this newsletter, please let me know. Besides this newsletter, another great resource to help you master Excel is to visit my website and review all my past tips. Most people don't absorb everything they read the first time. Sometimes taking a second look will trigger new ideas about how you can use a tip.

I hope you'll have a great week and I'll see you again next week.

To Your Success!
Francis Hayes (The Excel Addict)

As always, it's a good idea to also know aboard shortcut. For this you would use CTRL+A.

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.

For example, assume you have a workbook that contains a lot of formulas that contain a tax rate. You could simplify things by using one cell to store the tax rate, naming that cell 'Rate' and then, instead of using the cell reference in your formulas, you would use the name 'Rate'.

Try this:

1. Enter 45% (tax rate) in cell B5.
2. To name the cell, select Insert, Name, Define.
3. Type 'Rate' and click OK.
4. Now, in cells C10:C15 enter some numbers.
5. In cell D10 enter the formula =C10*Rate and copy it down to cells D11:D15.

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.

Here's a quick way to open any type of text file in Notepad simply by right-clicking on the file, and choosing Send To, Notepad. You do this by creating a shortcut to Notepad in the Send To folder.

1. Open Windows Explorer.
2. Browse to the C:\Windows\SendTo folder.
3. Right-click in the empty space next to the files in the folder and choose New, Shortcut.
4. In the Create Shortcut window, enter C:\Windows\Notepad.exe in the Command line box
5. Select Next
6. Remove the '.exe' from the name and click Finish.