Hi Fellow Excel Addict,

Welcome to another edition of "Spreadsheet Tips From An Excel Addict."

Well, the past 10 months of work with my soccer team paid off this past weekend. We hosted the long awaited 2004 Mega Tournament in our hometown and had a very successful tournament. Three wins, a tie and one loss were good enough to give us the gold medal. I was so proud of my girls. They played fantastic and represented our town very well. There were a lot of new friendships made that will last for a long time. What a great weekend! I wouldn't have missed it for anything.

Take a look at some pictures from our tournament at http://www.theexceladdict.com/photos/mega

Now that the tournament is over, I plan on putting some of my freed-up time into my website and ebook, which has practically been on hold for the past few months. As I've said before, I would love to hear any of your comments or suggestions that could help me improve my website, my ebook or my newsletter.

Have a great week and I'll talk to you again soon.

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 copy cells and paste them somewhere else, everything gets pasted including borders. However, often you'll want everything pasted except the borders. I noticed this little annoyance shortly after starting to use Excel many years ago.

Then I discovered that I could use Paste Special to paste just the Values, just the Formulas, or just the Formats. My solution was, after copying, to click Paste Special, Formula and then Paste Special, Formats. This became a routine for me when I wanted to paste everything except for the borders.

Since Excel 97, however, there has been a new Paste Special option added that lets me accomplish the same task in one step. Now I just click Edit, Paste Special, 'All Except Borders' and OK. It's so easy!

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.

Often you will use numeric headings in your worksheets. For example, you may have a table that uses years for the headings (i.e. 2004, 2003, etc...) Sometimes these headings may incorrectly get included in the calculations for some formulas, such as when you use AutoSum to total a column which has a numeric heading. Excel's AutoSum sees the heading cell as numeric, so it includes that cell in the formula. This can easily happen and likely will lead to costly and embarrassing problems.

There are a couple of ways to avoid this error. One is to precede the numeric value with an apostrophe (i.e. '2004). However, my preferred method is to format all of the heading cells, often the entire row, as Text.

Here's how:

1. Select the heading cells (or the entire row)
2. Select Format, Cells, click the Number tab.
3. Select Text from the Category box, and 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.

Have you noticed that sometimes when you reply to or forward an email, Outlook Express uses > marks to indent the original message. I said sometimes because this applies only to plain text messages.

When you reply to or forward an email and see all those > marks, you can easily prevent them from showing up in the first place. Before you click on Reply or Forward, go to Tools, Options and click the Send tab. You'll see two Plain Text Settings buttons. Click on the first one and a dialog box will pop up. Remove the check mark from the "Indent the original text..." option and then click OK and OK again.

Now you can select the message to reply to or forward and the > marks will be gone.