Hi Fellow Excel Addict,

I hope everything is well with you and your family. Now that the weather has improved enough here in Newfoundland to get back on the soccer fields, I am feeling much better. That clean, fresh air sure feels good after spending the last 6 months playing soccer in a stuffy school gym.

You'll have to excuse me if my newsletter is occasionally late getting out over the next few months. But don't worry, you won't miss either one. With coaching a Girls Under-14 All-Star team twice a week, various games and tournaments, part-time taxi driver for two teenage daughters, in addition to some Internet projects I'm planning, things are going to be pretty hectic around the Hayes household.

After receiving several requests, I have decided to publish an eBook containing my tips, tricks, shortcuts, and tutorials. I am interested in getting some suggestions and feedback from my readers on what you'd like to see in this book. After all, this book will be written for Excel users like you, who want to take their skills to a higher level. I do appreciate your opinion.

Till next week, take care and keep Excelling!

To your success,
Francis J Hayes (The Excel Addict)

P.S. Remember to include "TheExcelAddict" in the Subject line of any emails you send me. This will help them stand out in the flood of junk email I have been receiving lately.

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/

Sometimes you will need to just print a workbook that isn't open. Typically, you would Open the workbook, Print it and Close it. That's three steps! You can, however, print a closed workbook in one step.

From Excel click File, Open, browse to the file, right-click the file and choose Print. Excel will automatically open the file, print it, and close it. Note that this will print only the pages from the sheet that was active when the file was last saved.

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 francis@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
March February January December November October September August July June	Mike Lowry, Cairnes, Australia 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

Excel offers many different predefined number formats that you can apply to your data. However, Excel doesn't always have exactly what you need.

For example, if you were an automotive parts dealer and your parts are assigned inventory numbers such as 5-656-5987, typing a lot of these part numbers can get very tedious, especially with inserting the dashes.

What you need here is a custom number format.

1. Select the range of cells that will contain the part numbers.
2. Choose Format, Cells and click the Number tab.
3. Under Category, select Custom
4. In the Type box type #-###-####.
5. Click OK

Don't worry about all the funny looking symbols you see in the Custom Number Format dialog box. Just remember that the # symbol is a placeholder for the formatted digits of your number. If you want you number to contain leading zeros for part numbers that aren't 8 digits long (as in this example), use 0s in the custom number format instead of the #s (i.e. 0-000-0000). Then, if you enter a number such as 123 it will display as 0-000-0123.

In a future newsletter I will go into more depth explaining Custom Number Formatting.

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.

If you frequently move or copy files between folders in Windows Explorer you, no doubt, have come across one or both of these situations.

1) You are dragging a file from one folder to another and change your mind.

2) You are dragging a file from one folder to another and accidentally release the mouse button and drop the files, but you don't know which folder you dropped them in.

When I was first learning Windows, making one of these blunders was a little scary because I didn't know what to do. I started looking though the folders for the lost files. Luckily, there are simple solutions to each of these problems.

1) If you want to abort in the middle of a drag-and-drop, simple press the Escape key on your keyboard before releasing the mouse button.

2) If you accidentally drop a file in the maze of folders in Windows Explorer you can easily reverse that mistake by selecting Edit, Undo or using the keyboard shortcut for Undo (CTRL+Z).