Hi Fellow Excel Addict,

Welcome to another edition of "Spreadsheet Tips From An Excel Addict." I hope you found last weeks tips helpful.

Remember to take a few minutes each week to actually practice using these tips and shortcuts, even for those ones that, at first, may not seem to apply to your situation.

The simple act of doing these tips will often open your mind to other possibilities that you hadn't thought of previously. That's what it's all about, "expanding your knowledge of Microsoft Excel and how you can best use it to your benefit."

I hope this weeks tips will save you time, money, or frustration. Preferably all three.

Have a great week.

To Your Success!
Francis Hayes (The Excel Addict)

Visit Coach Dave at http://www.CoachingForTomorrow.com
or send a blank email to subscribe@CoachingForTomorrow.com.

Just try it. This is a trick you could use every day.

If you use Named Ranges, as I told you about a couple of weeks ago, you can quickly jump between sheets by pressing F5, entering a Named Range and hitting Enter.

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 t-shirt 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 use the 'Tell A Friend' link at www.TheExcelAddict.com you could win $10,000 and you will also qualify for my t-shirt draw.

*** Each monthly winner will be notified by email and will have 10 days to reply with a shipping address. If I don't receive a reply within 10 days, another name will be drawn.

Recent T-Shirt Contest Winners
June July August September	Lisa Hobbs, Pennsylvania, USA Keith Bannister, North Carolina, USA Beki Chambers, Indiana, USA Jim Henderson, California, USA

Next time here's what you can do:

1. Find a blank cell to the right of the cell containing the uppercase text and enter the formula =LOWER(origtext).
2. Replace 'origtext' in the formula with the address of the cell that contains the original uppercase text i.e. =LOWER("A1"). Excel will instantly convert it to lowercase.
3. Copy the formula down for each cell you want to convert.
4. Select all of the cells containing the formulas and click Edit, Copy.
5. Select all of the cells containing the original text and click Edit, Paste Special, Values, and OK.
6. Go back and delete the cells containing the formulas.

NOTE: It's always a good idea to backup your data before making wholesale changes to it like this. Better safe than sorry.

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.

Maybe you know someone who supervises or employs many Excel users. That's where your referral could have a big impact.

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 close a bunch of them all at the same time. Hold down the CTRL key and click on each program's button in the task bar. Right-click one of the selected buttons and choose Close.