Hi Fellow Excel Addict,

I hope you're having a great week. I've got some more tips for you that I hope you'll like.

I always try to make my tips easy to understand and to apply, but often when something is new to you, you may not 'get it' the first time through. Or even see how that tip may apply to you.

If this happens to you, my suggestion is to actually do the tip step by step. You'll be surprised at how many new things you learn that YOU REALLY CAN USE. One example is my tip this week on Custom Lists. Most Excel users have never heard of Custom Lists. But you'll see below how simple it is to learn and how many uses you can find for it.

If you ever have a question about any of my tips, or anything else for that matter, don't hesitate to ask.

I hope you have a fantastic week.

To Your Success!
Francis Hayes (The Excel Addict)

EXCEL SCREENSAVERS: Don't forget to check out the cool Excel screensavers in the new downloads section of my website. http://www.TheExcelAddict.com/downloads

DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA:
This is my hometown: http://www.conceptionbaysouth.ca/
This is my beautiful province: http://www.gov.nf.ca/tourism/

When you combine two previously separate workbooks that shared linked formulas, you may end up with some formulas in the newly combined workbook that are still linked back to the old workbook, which you are probably going to delete. Instead, you want these links to refer to the current workbook.

Fixing all of these links could be quite a task. But rather than editing them one by one, simply click Edit, Links, Change Source, browse to find the current workbook (Yes, the one you have open). Click on the filename and click OK.

All the links will update to the new combined workbook.

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 referral@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
February January December November October September August July June	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

Do you repeatedly have to enter the same list of values (i.e. city names, product names, etc...) in various workbooks?

I know what you're thinking, 'I can just copy the list from an existing workbook.' Sure, you can do that but then you have to find and open the workbook every time you want to create your list.

Wouldn't it be cool if you could instantly create your list 'out of thin air'?

Excel's Custom List option will let you do that. You probably already use Custom Lists in Excel. For example when you want to enter the twelve months of the year, you enter January in the first cell and then drag the fill handle to complete the remaining months.

You did know about that, didn't you? I thought you did.

Well it's really easy to create any list of values you want to work the same way.

1. First you need to tell Excel what you want in your list. So, enter the values of the list on your worksheet, in the order that you want them.
2. Now go to Tools, Options, and select the 'Custom Lists' tab.
3. At the 'Import list from cells' field, click on the small button with the red arrow to 'collapse' dialog box.
4. Select the range of cells containing your list and then click that small button again to restore the dialog box.
5. Click the Import button and then OK

Alternatively, instead of importing your list from the cells, you can type your list of values directly into the Custom Lists dialog box.

1. In the 'List entries' field, enter each value of your list on a separate line (i.e. press Enter after each entry).
2. Then click Add and 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.

For anyone who is a frequent computer user (I'm assuming you are), no doubt you have come across a situation where you have wanted to open a particular file in a particular program but when you double-clicked on the file, it opened in a different (default) program.

For example, if your text files (*.txt) open by default in NotePad and occasionally you need to open a text file in Microsoft Word, you have several options.

1. You can open Word and click File, Open and browse to open the text file.
2. In Windows Explorer, you can hold down the Shift key while clicking the File menu and that will give you a new 'Open With' option where you can choose which program to open the file in.
3. If the program you want to open the file in is already open, you can easily drag the file to the program's icon on the Windows taskbar and, with the mouse button held down, hold it there for a second or two until the program 'pops up', then drag and drop the file onto the program window and the file will open in that program.