Hi Fellow Excel Addict,

Welcome to another edition of "Spreadsheet Tips From An Excel Addict." It's great to hear that many of you are putting these tips to use and saving yourself lots of time and frustration. I always say that learning Excel is like earning compound interest. The more you learn, the more time you save, allowing you to learn even more ways to save even more time. However, my experience has been is that many employers 'just don't get it.'

But I believe you have a real passion to learn Excel and if you allow me, I will help you become significantly more productive.

Just remember that you 'learn to do by doing.' Take the time to practice these tips. You'll be glad you did.

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.

• Ctrl+PageDown selects the next sheet tab
• Ctrl+PageUp selects the previous sheet tab
• Ctrl+Shift+PageUp and Page+Shift+PageDown selects consecutive sheet tabs.

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.

T-Shirt Contest Winners
June July August September October	Lisa Hobbs, Pennsylvania, USA Keith Bannister, North Carolina, USA Beki Chambers, Indiana, USA Jim Henderson, California, USA Apollo Tigalo, Angeles City, Philippines

Rotate Your Column Headings

Sometimes you may find that you are working with data that requires narrow columns but your headings are wider than will fit in the column? You could try Word Wrap (Format, Cells, Alignment, and put a checkmark in Word Wrap). However, sometimes that may not be what you need.

For example, I have a worksheet to keep track of attendance for my all-star soccer team. I have all the players names listed down the left column and I have the dates of the practices across the top. Because I enter an 'o' to denote each players attendance for each practice, my worksheet requires only narrow columns. However my dates don't fit to the column width.

So, in order to display my dates without having to make my columns too wide, I change the orientation of my headings so that they are on an a 45 degree angle.

Just try it.

1. On a new sheet, adjust the width of columns C to H to 5.
2. Enter todays date in cell C2 (CTRL+;).
3. Drag the fill handle (the small black square on the bottom-right corner of the selection) and drag it across to cell H2.
4. Now select Format, Cells, Number, Date, and select the format that matches DD-MMM-YY (or something similar).
5. Select Format, Cells, Alignment, enter 45 in the Degrees box and click OK.
6. With your heading cells still highlighted, select Format, Cells, and click the Border tab.
7. Click on the Outline button, the Inside Button, and click OK.

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.

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.

When you click a link on a web page, it usually loads the new page in the same window. If you're like me, the new information often distracts you from what you were initially doing. Sometime later you realize that you got sidetracked and then have to find your way back to the original web page.

A simple way to avoid this is to open the link to the new information in a new window - leaving your original window still open. You simply right-click on the link and select Open Link In New Window. When you're done with the new window, simply close it and you'll be right back to the previous window.

This tip works especially well for web pages that contain thumbnail links to photo albums.