Hi Fellow Excel Addict,

Welcome to another edition of my newsletter.

Below you will find my Excel tips and my non-Excel tip. I hope you find them helpful. But this week I'd like to offer you an additional timely tip. This week there is an email worm virus spreading rapidly across the Internet. I can't go in to the details here but I'd like to offer some advice.

It is always a good policy never to open emails with attachments unless you know who they are coming from. Even if you do recognize the person that sent it, you should not open the file unless you know what the file is and you were expecting it. If you're not sure, call or email the sender and ask them if they sent you the file.

Here is an excerpt from an article I read today... "The worm, called Mydoom or Novarg by anti virus companies, appears to be an e-mail error message. A small file is attached that, when launched on computers running Microsoft Corp.'s Windows operating systems, can send out 100 infected e-mail messages in 30 seconds to e-mail addresses stored in the computer's address book and other documents."

I'm receiving so much junk email everyday that I don't want to take any chances, so I delete all emails with no SUBJECT line. In light of this, anytime you send me an email, please ensure that your SUBJECT line makes it clear that it is an Excel-related topic.

Have a safe, virus-free week.

To Your Success!
Francis Hayes (The Excel Addict)

Select File, Open and browse to the folder of the workbook you want to duplicate. In the Open dialog box, click on the small drop-down arrow on the Open button and you will see several options including Open As Copy. Select Open As Copy and a new workbook identical to the original will be created (with no risk of overwriting the original).

Note that when you select Open As Copy, Excel immediately creates an identical workbook and saves it to the same folder as the original with the name "Copy of original filename". Even if you close this workbook without saving it, the duplicate file will still remain in the folder. If you use Save As to save this workbook with a different name, you may want to delete the "Copy of" version from the folder.

Jim Rohn's Weekly E-Zine is a free weekly publication dedicated to providing valuable insights and information that can help empower and improve both your business and personal life. Find out more at http://www.JimRohn.com.

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

As you know, an Excel workbook can contain many individual worksheets. Often you will find that some of your workbooks are made up of multiple worksheets that are identical in every way except for the input data. For example, you may have twelve monthly sheets plus a summary sheet.

You probably already know that you can print multiple sheets by holding down the CTRL key and selecting each sheet tab you want to print (or click the first sheet tab, hold down the SHIFT key and click on the last sheet tab). Sometimes you may want to print just a small identical selection from each sheet.

Here's how:

1. Select the first worksheet you want to print.
2. Select the range of cells that you want to print.
3. Hold down the CTRL key and select each of the other sheets tabs you want to print. If the sheets are all together, you can click the first sheet tab, hold down the SHIFT key and click on the last sheet tab.
4. Select File, Print, and click the Selection option in the 'Print What' section. At this point you may want to click the Preview button to make sure you've got it right.
5. Click OK to print.

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.

At first glance, you may think that pressing the Print Screen key will print what's on your screen - a reasonable assumption. Actually, the function of the Print Screen key is to capture a screenshot or picture of your computer screen and copy it to the Windows Clipboard. The Clipboard is a holding place in your computer's memory where Windows temporarily stores data after you use the Cut or Copy command until you paste it.

You have two options with the Print Screen key. You can capture a screenshot of your whole computer screen or just the currently active window or dialog box. To capture the whole computer screen, which may consist of multiple overlapping windows and/or dialog boxes, you simply press the Print Screen key. To capture just the currently active window, first hold down the ALT key and then press the Print Screen key. Remember, at this point the screen capture is just sitting on the clipboard waiting for you to paste it somewhere.

As an Excel user, I usually paste all my screen captures in Excel - just click where you want to paste the picture and select Edit, Paste (or press CTRL+V). You can also paste the picture in most graphics (i.e. Windows Paint), word processing (i.e. Microsoft Word or WordPad), or many other programs.

Just try it and see if you can think of cool uses for this often forgotten tool.