Hi Fellow Excel Addict,

Did you find last week's tips helpful? We looked at Updating Links To The Current Workbook, Custom Auto Fill, and 'Open With' File Options. If you just signed up in the past week you can find those tips here online.

This week I've got some more pretty cool tips that I think you'll like. Take a look and let me know what you think.

Have a great week.

To Your Success!
Francis Hayes (The Excel Addict)

DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA:
This is where I grew up: http://www.brigus.net/
This is where I now live: http://www.conceptionbaysouth.ca/
This is my beautiful province: http://www.gov.nf.ca/tourism/

How often do you format numbers on your worksheets to Currency format?

Here's a quick tip that's easy to use and easy to remember.

Pressing CTRL+SHIFT+$ will apply the Currency format with two decimal places and negative numbers in parentheses to the cells you have selected.

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.TheExcelAddict.com/rd/jimrohn.htm.

All you have to do to qualify each month is send an email to your Excel friends and associates recommending my newsletter and website. Include a BCC to referral@TheExcelAddict.com and for each person that you refer, your name will go into the draw. Please, recommend only to people you know and who are Microsoft Excel users.

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 draw. The more Excel friends you refer, the more chances you have of winning, 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 Referral Contest 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.

Referral Contest Winners
February January December November October September August July June	Ashley Rankine, Perth, Australia Luis Bolivar, Maracaibo, Venezuela 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

Anytime you need to reorganize sheets among several workbooks, it can be quite a chore switching between workbooks and copying or moving the sheets. That's if you haven't discovered the easy way.

Yes, there is an easier way! Much, much easier!

Step 1: Arranging The Windows

1. First close all workbooks except for those you wish to reorganize.
2. From the menu select Window, Arrange
3. The Tiled option should already be selected. You can also try the other options to see which one you prefer.
4. Click OK

Step 2: Dragging and Dropping

Now that have your windows arranged, you can easily drag and drop sheet tabs from one workbook to another. But here are some things you should know about.

• You must first 'activate' (i.e. click on) a window before you can do anything with it. So, the first click on either window activates it.
• To 'move' a sheet to another workbook, click on the sheet tab and, while holding down the left-mouse button, drag it across to the destination workbook. Position the mouse pointer over the sheet tabs until the small black arrow is in the position you want to insert the sheet and release the mouse button.
• To 'copy' a sheet instead of 'moving' it, hold down the CTRL key on your keyboard while dragging and dropping the sheet tab. You will notice a small plus sign beside the sheet icon as you are dragging, indicating that the sheet is being 'copied.'
• If a sheet with the same name already exists in the destination workbook, Excel will add a number to the end of the sheet name. You can then rename it.
• If you move all of the sheets from one workbook to another, that workbook will 'disappear' from the Excel window however the original workbook with all of its sheets will remain in its original folder.
• When you try to close a workbook from which you have moved sheets you will be prompted to save changes. If you choose to save changes, the workbook will be saved without the moved sheets. If you don't save the changes, the original workbook file, with all of its sheets, will remain in its original folder.

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.

Do you often see a picture or other graphic on a website that you'd like to save? Simply right-click on it, click Save Picture As, select the folder where you want to save it and click the Save button. That was pretty easy, right?

Well, now I'm going to show you another even faster way.

1. Open Windows Explorer and open the folder where you want to save the graphic.
2. Resize your browser window so that it takes up the left half of the screen and the right side (2 pane view) of the Windows Explorer window is visible behind.
3. Position your mouse pointer over the graphic you want to copy.
4. If the pointer changes to a 'white arrow' you can just drag (using the right mouse button) the graphic from your browser and drop it right in the folder in Windows Explorer. Select 'Copy here' from the popup menu and the graphic is saved to the folder.
5. If the pointer changes to a 'hand', that means that the graphic is a hyperlink to another document. In that case you'll have to right-click on the graphic and select Copy from the popup menu, right-click the Windows Explorer window and click Paste from the popup menu and the graphic is saved to the folder.

BONUS TIP: You can also insert a graphic directly into Excel by using right-click, Copy and right-click, PasteSpecial, Bitmap.