Hi Fellow Excel Addict,

I hope you're having a great week. The responses I received from my email asking for your opinion on my giveaway prize were phenomenal. I'll have a separate email going out later with more details on that. To everyone who responded, Thank You!

I hope you avoided that email worm virus. I received hundreds of those infected emails but I was smart enough to delete them.

Just another reminder if you want to send an email to me. I get so much junk email, it is sometimes difficult to determine which emails are good and which are junk. To make sure I don't accidentally delete an email from you, please put "Excel Addict" in your Subject line. That way I won't miss it. If you are responding to one of my emails or newsletters, just Reply to it as usual and there's no need to change the Subject line. I wouldn't want you to think I'm ignoring your emails.

Well , I have more new tips for you this week. I hope they help make your week a little easier.

To Your Success!
Francis Hayes (The Excel Addict)

Here are some tricks that will allow you to edit a cell without reaching for your mouse.

1. Use the arrow keys to move to the cell.
2. Press the F2 key to enter edit mode.
3. While in edit mode, use these tips to make changes.
   • Use the arrow keys if you need to select cells to use in your formula. When selecting cells, remember to press F2 to toggle between edit mode and select mode.
   • Press the HOME key to move the cursor to the beginning of the formula.
   • Press the END key to move the cursor to the end of the formula.
   • Hold down the CTRL key plus the left or right arrow to move quickly through the formula.
   • Hold down the SHIFT key and use the left or right key to highlight a part of your formula.
   • Press the END key and then CTRL+SHIFT+HOME to select the whole formula.
   • If you need to, you can copy (CTRL+C) and paste (CTRL+V) parts of your formula.
4. When you've finished making changes to your formula, press ENTER to accept the changes or press the ESC key to cancel changes (i.e. if you've made a mistake).

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

There may be times when you want to show a cents symbol (¢) for values that are less than $1.00 and a dollar symbol($) for values that are a dollar or more. To do this you need to use a "conditional number format" (i.e. a number format that depends on the condition). If the condition is that the value in the cell is less than a dollar, the cents symbol will be displayed (i.e. .87¢) otherwise, the dollar symbol will be displayed.

To create this conditional number format...

1. Select the range of cells you want to apply this format to.
2. Select Format, Cells, and click the Number tab.
3. In the Category field, select Custom.
4. In the Type field, enter [<1].00¢;$0.00_¢
   Note: You can copy this format directly from this email or if you enter it yourself, remember that to get the cents symbol you need to hold down the ALT key and enter 0162 (don't forget to enter the zero before the 162) then release the ALT key.
5. 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.

1. Select a file in Windows Explorer.
2. Press CTRL+C (copy)
3. Select the folder where you would like to place the copy and press CTRL+V (paste)

Here's another great tip to use when copying a single file or multiple files in Windows Explorer.

1. Select the file you want to copy (for multiple files hold down the CTRL key and select each file).
2. Make sure the destination folder is in view in the left pane of your Explorer window. Drag the selected files by holding down the CTRL key and holding down your left mouse button then drop (i.e. release the mouse button) them in the destination folder.