Hi Fellow Excel Addict,

Welcome to another edition of my tips newsletter. I hope everyone is enjoying their summer, unless, of course, you're in the Southern Hemisphere enjoying Winter. Out here on the east coast of Canada we have been having unusually cool weather lately, so I'm still waiting for my summer to start.

Once again, I want to thank everyone who is helping me share my newsletter and website with other eager-to-learn Excel users around the world.

Your feedback on this weeks tips would be appreciated.

To your success,
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/

This is something I use quite often. When you want to show row numbers for a long list which you remove and add rows to, use the following formula...

=ROW()-n   (where n is the number of rows before the first row of the list)

So, for example, if you have a list of names in column B starting in cell B5 and you want row numbers in column A, you would enter =ROW()-4 in cell A5 and copy the formula down column A to the bottom of your list.

Now whenever you delete a row, the row numbers adjust automatically. When you insert rows, the row numbers will again adjust automatically, however, you'll have to copy the formula from the cell above to the new rows.

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

How many times have you seen a printed report and wondered who created it and when? How often have you had a printed spreadsheet but couldn't remember the filename? I've seen people start over from scratch because they couldn't find the workbook that the report came from. Often reports get distributed to others who have no idea where they came from. To the reader of a report, when a report is created and printed is often useful information. Using headers or footers on your reports is a great habit to get into that could save you and others a lot of grief.

If you're not familiar with headers and footers, here is a quick introduction. Headers and footers contain information that you may want to print at the top of each page of your report, such as page numbers, print dates, filenames, etc... These are different from column headings, which you can print at the top of each page. Header and footer information is contained in your print settings not in the cells of your worksheet. Headers print on the top of each page. Footers print on the bottom of each page.

The most common use of headers is to display page numbers (i.e. Page 1 of 19). Excel offers the most commonly used headers as presets that you can choose from a dropdown list. Select File, Page Setup, Header/Footer, click on the Header or the Footer dropdown and choose one of the preset options. The preset options can be placed either on the top of the report, on the bottom of the report, or both. You have no control as to whether the presets print on the left, in the center, of on the right. Some of them will contain information that will print on the left, right and center of the page.

You also have the option to create your own custom headers and footers. Select File, Page Setup, Header/Footer, click on the Custom Header or the Custom Footer buttons. Decide if you want your header or footer on the left, right, or centered. Click in the appropriate box and type in what you want printed as part of your header or footer.

You'll notice buttons in the Header and Footer dialog boxes. The first one is the Font Button. It allows you to change the font of the information you have selected. The second button is the Page Number Button. This button inserts code that tells Excel to print page numbers. The third button is the Total Pages Button. This is commonly used in conjunction with the Page Number code. For example, to have your header print "Page 1 of 19", you would type "Page " (without quotes), click the Page Number Button, type "of ", and click the Total Pages Button.

The fourth button is the Date Button. This button inserts code to tell Excel to print the date in the header or footer. The date used is the date that the report is printed. Next is the Time Button. Printing the time and date in your header or footer helps when you make frequent revisions to your work and need to know which printed report is the most recent.

Using the next two buttons, the File Name Button and the Sheet Name Button, make it easy to match your printed report with the file on your computer.

Aside from the codes that Excel allows you to put in your header and footer, you can type almost anything else to suit your needs. The company I work for uses the following very useful information as a standard in our footers: Filename, Originator, Date, Time. The printed footer looks like this...

June Expense Report.xls (Orig. F Hayes)
31/5/04 11:45AM

Now when anyone gets a report, they know who produced it and when.

Headers and footers are another of Excel's features that most users do not fully utilize because they do not understand their capabilities. Hopefully my (rather lengthy) tutorial will help you appreciate their usefulness.

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.

How many times have you been printing several documents and lost track of which ones you had sent to the printer? Say you are on the Internet and have found a site that contains a ten-step article (one step on each page) that you'd like to print. You are half way through printing and are interrupted. Now you don't remember if you printed step 6. Do you wait till everything finishes printing to find out?

No way! Notice the small printer icon that appears on the Windows taskbar when jobs are printing. Double-click it and you'll see the status of your printing jobs.