Hi Fellow Excel Addict,

Welcome back for another edition of my newsletter.

I have three new tips this week that I hope will find helpful.

Hey look! My soccer team got out picture in the newspaper. Take a look here.

We have another tournament this weekend. Wish me luck!

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/

I'm always surprised at that most Excel users use only the Borders tool on the toolbar and assume that borders are only solid, black, thin lines. In fact, when applying borders to your worksheet there are several options available that you won't find on the Borders tool that allow you to spice up your worksheet.

Select Format, Cells and click the Border tab. You'll see that you can use different colors for your borders - even in the same cell. You can create borders of various thickness. There are several formats of dashed borders to choose from. You can even created diagonal borders.

I've said it many times before, "You've got to do some digging to find all of the goodies that Excel has to offer."

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.

Sometimes you may be using dates in your worksheet and want the cell to show the day of the week (i.e. Sunday, Monday,..) rather than a date. You could simply type in the day of the week in the cell, but if you have formulas in your worksheet that refer to that cell, those formulas would get messed up. What you need to do is create a custom number format for the cell containing the date.

To create a custom number format for the day of the week is easy.

1. Select the cell containing the date you want displayed as a weekday.
2. From the menu select Format, Cells, and click the Number tab.
3. In the Category box select Custom from the list.
4. Type dddd in the Type field on the right side of the dialog box
5. Select 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.

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.

Many people have figured out that they can press the Tab key to move from one 'control' to another in most programs. Controls are the objects in a program that you interact with such as buttons, text boxes, option buttons, etc...

On the other hand, it has also been my experience that most people don't realize that they can move backwards through these same Controls by holding down the Shift key while pressing the Tab button.

Notice that I said "many people" have figured it out. I often see people filling in a form by clicking on the first field with the mouse, typing with the keyboard, reaching for the mouse and selecting the next field, then back to the keyboard to fill in that field, reaching for the mouse again to click the next field. On and on till the form has been completed.

Using the Tab key to navigate these controls is a much more efficient method. If you see someone doing this 'keyboard-mouse shuffle', please do them a favour and tell them about the Tab key.