Hi Fellow Excel Addict,

Welcome to another issue of 'Spreadsheet Tips From An Excel Addict'. I hope you had an awesome week.

Last week we looked at some great tips for 'Zipping Through Your Sheet Tabs', 'Extracting Unique Items From Data In A Column', and 'Using Bcc To Keep Forwarded Email Addresses Safely.' Did you find these tips helpful?

This week you will learn three more tips that I hope will help you be more productive and make working with Excel (and Internet Explorer) more enjoyable for you.

Please feel free to share this newsletter with your Excel friends and colleagues. There's a great quote by Zig Ziglar that says, "You can get everything in life you want, if you help enough other people get what they want." So help other Excel users by sharing these tips and tricks and they will love you for it.

Have an awesome week!
Francis J Hayes (The Excel Addict)

P.S. Remember to include "TheExcelAddict" in the Subject line of any emails you send me. This will help them 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/

Often in Excel, you will decide to make some major changes to one of your workbooks but, at the beginning, you're not 100% sure that you will be happy with the results.

Rather than risk ruining your original file, first open the original workbook, click File, Save As, enter a new name and click Save. The open file now becomes the new renamed (identical) file and the original file is safe on your hard drive.

Neil Kosterman, one of my subscribers, suggested also using a numbering system for your backup files (i.e. v1 = version 1, r1 = revision 1, etc...)

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
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

What's the best way to create a column that stores cumulative totals?

Let's say you have a data table. In Column A you list the days of the month, 1 to 31. In Column B you enter your daily totals (i.e. sales, rainfall, etc...). Assuming Row 1 is used for column headings, your daily totals will be entered in cells B2:B32. You want to keep a running month-to-date total in column C.

Here is a really easy solution that you can use:

Using the scenario above, you enter =SUM($B$2:B2) in cell C2, and copy that formula down column C. Note the dollar signs in the first cell reference in the formula ($B$2) and no dollar signs in the second cell reference (B2). The dollar signs indicate an "absolute reference". This means that when you copy this formula down column C, the reference to $B$2 won't change. The second cell reference to B2 doesn't have dollar signs, so that means it is a "relative reference" and will adjust as it is copied. When the formula is copied to cell C3, the formula becomes = SUM($B$2:B3) and the result will be the sum of the range B2:B3. As you enter values in column B, the formulas in column C will show the cumulative totals.

After you have copied these formulas down column C, you will notice that the cumulative totals in the rows below the last value in column B all show the same cumulative total. To avoid showing cumulative totals for the rows that have no value entered in column B, you will need to modify the formula I just gave you. Go back to cell C2 and enter this formula instead and copy it down column C as far as C32.

The formula in cell C2 will be =IF(B2="","",SUM($B$2:B2))

This says, if cell B2 is blank then don't put anything in cell C2, otherwise add a cumulative total formula. Now, as you enter the amounts in Column B for each day, the cumulative total will appear next to each amount.

If you would like to see a sample spreadsheet of this tip, you can find it here.

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.

Internet Explorer 6.0 automatically resizes large images to fit your screen. This allows you to see the whole image at once. If however you are often view large high-resolution pictures, you may no want this to happen. To prevent Internet Explorer from resizing large images, here's what you can do.

1. From the Tools menu select Internet Options.
2. Click the Advanced tab.
3. Scroll down to the Multimedia section.
4. Remove the check mark from 'Enable Automatic Image Resizing'.
5. Click OK.