Happy New Year Fellow Excel Addict,

I hope you had an enjoyable holiday season.

Tina, Kristen, Stephanie and I enjoyed ourselves immensely visiting friends and relatives and sampling lots of good food.

Now as we get back into the swing of things for a new year after a two week break, I will be sharing many more tips with you in the months ahead. I hope you find these tips helpful and make your life a little easier.

Have you applied any of my tips and found them to be a big help to you?

Let me know. I'd love to hear from you.

Till next time...

To Your Success!
Francis Hayes (The Excel Addict)

It's pretty simple. Copy and Paste. Right?

One thing you will notice when you first try this, is that the information is pasted into Excel with the original formatting from the web page intact. Often, this will be exactly what you want.

Sometimes you'll find that even graphics and HTML code gets pasted along with the data. Therefore, there will be times when you want to paste just the plain text, without the formatting.

Well, that's pretty simple too.

Select the text on the webpage that you want to copy, select Edit, Copy from your browser's menu (or use CTRL+C). Switch back to Excel and select Edit, Paste Special and choose the Text from the list of options.

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
December November October September August July June	Joseph Mathew, Dubai, United Arab Emirates Alexandre Gusmao, Lisbon, Portugal Apollo Tigalo, Angeles City, Philippines Jim Henderson, California, USA Beki Chambers, Indiana, USA Keith Bannister, North Carolina, USA Lisa Hobbs, Pennsylvania, USA

You may have workbooks with sensitive information that you don't want others to see. Excel allows you to save a workbook so that a password must be used to open or modify it.

1. Excel 97: Click File, Save As. In the Save As dialog box click the Options button.

   Excel 2000 / Excel 2002: Click File, Save As. In the Save As dialog box select Tools (from the toolbar) and General Options.

2. Type a password in the 'Password to open' box to prevent others from opening the workbook without entering the password.

   Type a password in the 'Password to modify' box to prevent a user from making changes to the file. The user can still save the file with a different name.

3. If you select the 'Read-only recommended' option, the user will be prompted to open the file as read-only unless changes will be made. You can use this option without requiring a password.

Caution: If you assign password protection to a workbook and then forget the password, you cannot open the workbook, access its data through links in another workbook, remove protection from the workbook, or recover data from the workbook. Keep a list of passwords and corresponding workbooks in a safe place.

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.

But there's an even easier way. With the file selected just hit the F2 key on your keyboard and type the new name.

I also use this tip when I need to copy a filename to another document. Just four simple and quick steps.

1. Hit F2 to edit,
2. CTRL+C to copy,
3. ALT+Tab to switch to the other document,
4. CTRL+V to paste.