Hi Fellow Excel Addict,

Having spent more than ten years working with Excel and learning many of its tricks and shortcuts, I just love helping others discover Excel's, seemingly limitless, capabilities. Funny thing is, there are many Excel users (a surprisingly high percentage) who are completely satisfied to just plod along in Excel with what little knowledge they have. Often, these same people will brush off any suggestions for improvement saying, "No thanks, I prefer to do it my own way."

It's easy to say, "Oh well, that's their loss" but if you think about, the time and money, through lost productivity, must be staggering for many businesses. One of the slogans I use on my website is, "Double, triple, even quadruple your productivity in Microsoft Excel." I honestly believe that just by learning tips and shortcuts for some of your most common tasks in Excel, you can easily double, triple or quadruple your productivity.

I'm glad YOU'RE not in that group. I know that you are interested in expanding your knowledge of Excel just by the fact that you are reading my tips every week. I get satisfaction out of sharing my knowledge with you. So, thank you.

I would like to hear about your experience with other Excel users. What was your experience in getting help with Excel in the past? Have YOU tried to help other Excel users? Were they receptive to your suggestions? Please share your story with me.

Keep on Excelling and have a great 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/

Most of the time, the gridlines displayed in Excel are very useful, especially as you are designing your worksheets. For some workbooks, however, you may want to have the gridlines hidden.

To turn off the gridlines for a particular worksheet, select Tools, Options and then select the View tab. Now uncheck the Gridlines option and click OK.

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 t-shirt draw. The more Excel friends you refer, the more chances you have of winning a t-shirt. 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 t-shirt 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.

T-Shirt Contest Winners
January December November October September August July June	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

As you know, when you copy a formula in Excel, the cell references adjust to the new location (unless the formulas have absolute references). For example if you copy a formula that refers to a cell two rows up, when that formula is copied to another location, the new formula will also refer to a cell two rows up from the new location.

However, there may be times when you may want to copy formulas to a new location but leave the original cell references intact. One way to do that is to first convert all the formulas to absolute references before copying. For multiple cells, that could be very time consuming. Another option could be to select the formula in the formula bar and copy them one by one. This would be fine for one or two formulas but wouldn't be practical if you have many formulas to copy.

Here's a neat (and fairly simple) trick to accomplish this task with minimal effort.