Hi Fellow Excel Addict,

Welcome to another edition of my newsletter. Are you getting some good tips that are helping you save time every day? If you have any suggestions for my newsletter I would love to hear them. Just email me at francis@TheExcelAddict.com

Congratulations to Beki Chambers of the USA. Beki is the most recent winner in my T-Shirt Contest. When people subscribe to email newsletters they sometimes change their email address or for some other reason do not receive it. That presents a little problem for me when I select a winner for my t-shirt contest and get no reply from them. I still have no one claim my August t-shirt.

So what I'm going to do just this one time is ask you to send me an email telling me about yourself and your experience with Excel and I will pick one name from everyone that replies, and that person will win a t-shirt. Send the email ASAP to francis@TheExcelAddict.com with T-Shirt Contest in the Subject field.

You have until Friday, October 24th to qualify to win.

I hope you enjoy this weeks tips and have a great week.

To Your Success!
Francis Hayes (The Excel Addict)

Another cool thing to do is, if your hyperlink is to a website (no, it doesn't HAVE to be to another workbook), you can copy a picture right from your browser (right-click on the picture and choose Copy) and paste it right into your Excel workbook (Edit, PasteSpecial, Bitmap).

Once you have the picture pasted in your worksheet, right-click on it, select Hyperlink and browse to or type in the address you want to hyperlink to.

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.

One way is to merge all the cells across the top of your report into one cell and center align it (Format, Cells, Alignment, Merge cells). One drawback to this method is that it changes the column and row structure of your spreadsheet which may cause you problems in the future such as selecting a range of cells that intersects with merged cells.

The other method is called Center Across Selection.

1. Ensure that the text for your headings is in the left-most column of your report.
2. Highlight the cells containing the headings and extend the selected range over to the right-most column.
3. Now choose Format, Cells, and select the Alignment tab.
4. From the Horizontal drop-down box scroll to the bottom, select Center Across Selection 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.

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

You probably know how to delete a word by selecting the entire word and pressing Delete. But did you know there is an even faster way?

As you're typing and you need to delete the word to the left of the cursor, simply hold down CTRL and then press the Backspace key. To delete the word to the right of the cursor, hold down CTRL and press the Delete key. That's much easier than having to reach for the mouse each time you need to delete a word.

To quickly delete many words, repeatedly press or hold down the Backspace or Delete key in the above steps.