Hi Fellow Excel Addict,

I just finished three evenings at a soccer coaching clinic. I am now qualified to coach youth over 14 years. I have a soccer tournament coming up this weekend and my team is really looking forward to it. I hope they don't find out about my birthday. A bucket of ice water down the back of my neck doesn't appeal to me.

Anyway, I'm just two days away from my summer holidays. Yippee! After a long year I'm really looking forward to a break from my JOB (just over broke).

I WILL still keep the tips coming, as I will not be travelling far on my vacation. My vacation will probably consist of work around the house, visiting my parents, coaching soccer, and I may even fit in a little relaxation. Of course, I will be taking lots of pictures with my new digital camera.

You know what I just thought of that would be neat; if you could send/email me a picture from your corner of the world (with you in the picture, of course). If you give me permission, I could even post it on my website. Sort of a Global Excel Addicts photo album.

I look forward to hearing (and seeing) from you.

Until next week ...

Keep on Excelling,
Francis J Hayes (The Excel Addict)

P.S. VERY IMPORTANT Please remember to include "TheExcelAddict" in the Subject line of any email you send me. This will help it 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/

When you are working in Excel and you click the Print tool on the toolbar, by default, only the current sheet is printed. If you need to print your entire workbook (i.e. all sheets), you have some options; some are better than others.

Something that I have seen a few people do is select each sheet tab and print them individually. This is not a good use of your time. Another option you have is to choose File, Print, and then select the 'Entire workbook' option from the dialog box. Yet another option is to select the first sheet tab, hold down the Shift key, select the last sheet tab, and then click the Print tool on the toolbar. Your entire workbook will be printed with no questions asked.

Personally, I use the last one. You may find the second one simpler. Try both and then choose whichever one feels better to you.

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

Say you have several lists of data and you want combine them into one list. Maybe they are on different worksheets or even in different workbooks. You have a couple of options. You can copy and paste each list individually, typically what most Excel uses do, or you can copy everything first and then paste them all in one step.

I'll use an example to explain this. Say you have a workbook with separate sheets for each soccer team and each sheet contains the names of soccer players. You want to create a summary worksheet with all of the names together for tracking stats.

You can go to the first team sheet, copy the names, switch to the summary sheet and paste, go to the next team sheet, copy the names and so on. Another option which you may not be aware of is that Office allows you to copy multiple items of data from various worksheets (or even other Office documents) and then paste them in other documents. You can paste them in any order or paste them all in one step. The big secret here is that you need to use the Office Clipboard, which you may or may not have seen. The copy and paste buttons for the Clipboard are on the Clipboard Toolbar. Normally when you copy two items in a row, the Clipboard toolbar will appear automatically. However, if it doesn't appear, you can right click on any toolbar and select Clipboard from the list of available toolbars.

In this simplified example, you can copy the names from the first sheet, copy the names from the next sheet, and when you have the names from all sheets copied (maximum allowed is 12), you can then switch to your summary sheet and paste them all in one step.

Just try it and see how it works!

The Clipboard also gives you the option of pasting the individual items in any order.

When you have multiple items on the clipboard, it may be difficult to remember which item is which. A little trick I've learned is to pause your cursor over the clipboard item for a second and you'll see a small Tool Tip pop up showing a small part of that item. Click on the individual item and it will be pasted.

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.

Most people have seen the little question mark in the top right- hand corner of most Windows dialog boxes. But most users never even question what it's for.

Just try it. Click on it and a question mark attaches to your cursor arrow. Then click on anything in the dialog box and a very helpful explanation of that dialog box item will pop up.