Thanks for joining me for another edition of my newsletter. As I said before, I love helping anyone who loves Excel as much as I do. And the fact that you are reading this newsletter today tells me that you want to learn more.

If you are new to my newsletter, you will find lots more tips on my website at TheExcelAddict.com. Over the past several months I was heavily involved in coaching my under-14 girls all-star soccer team and, as a result, I have a backlog of tips from my newsletters that I haven't put on the website yet. But over the next week or so I will be bringing things up-to- date.

Below are three more tips to help you on your way to becoming an Excel Addict. I hope you like them.

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/

Many times when you input data in your worksheets, the data you enter at the bottom of a list is often a duplicate of data in the cells above. To quickly duplicate these entries, right-click on the empty cell directly below the list and selecting 'Pick From List'. You will get an alphabetical list of all entries from the cells above to choose from.

Much quicker than typing - especially if your typing skills are anything like mine.

(From a previous tip: Alternatively, you can use ALT+Down Arrow instead of right-clicking)

Mark Victor Hansen, author of the mega best-selling 'Chicken Soup' book series wants to help you. Sign up for his weekly 'Rich Results' subscription. It’s absolutely free, no strings attached.

I use footers in almost all of my worksheets. In the footer I include the sheet name, filename, my name, time and date. I've found this practice very useful in helping me later on in identifying which workbook produced the printed report and if the printed report is the latest version. Also, many of my reports are distributed to other people in our company and the readers of the report can quickly see who originated it and when it was produced.

Also, I like to keep the text of my footers very small so that they don't stand out but can be easily read if the reader of the report needs that information (see last line of this tip).

Many people don't realize that you can change the font of your headers and footers. Here's what to do. (Note that the following instructions talk about footers but they apply equally to headers.)

1. From the View menu select 'Header and Footer...'
2. If you worksheet doesn't already have a footer, select one from the dropdown list of built in footers or click the Custom Footer button and create one of your own.
3. If you selected a built-in footer, you will need to click the 'Custom Footer' button.
4. To change the font of your footer, select the text to be formatted.
5. Click on the Font icon (the one with the letter A on its face).
6. Select the desired font formatting.
7. Click OK to close the Footer dialog box.
8. Click OK to close the Page Setup dialog box.
9. Click File, Print Preview to check out the changes you just made.

Some Additional Notes On Headers and Footers:

• You can apply different formatting to different parts of the footer text by selecting only a part of the text.
• You are not limited to the font sizes listed in the Font dialog box. Just type whichever size you want in the Size box.

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.

We all know that to Maximize or Restore a window we click on the middle button of the three small icons on the top right-hand corner of the window. Those buttons are pretty small and, I don't know about you, but sometimes I accidentally click the X button and close the window by mistake.

Here's a bigger target for you to click on. Double click the title bar (i.e. the colored bar at the top of the window) and it will Maximize a window that is not maximized and restore a window that is maximized.