Welcome to
SPREADSHEET TIPS FROM AN EXCEL ADDICT
(Online Edition)

Helping Average Spreadsheet Users
Become Local Spreadsheet Experts

A Free Weekly Publication of TheExcelAddict.com

Publication Date: February 26, 2004


I respect your privacy and promise not to abuse this privilege. This newsletter is sent only to those who have requested it. If you no longer wish to receive my tips, you'll find simple instructions at the bottom of every newsletter.

CONTENTS
  1. Editor Notes
  2. Excel "Quick Tip"
  3. Empower And Improve
  4. T-Shirt Contest
  5. "How To Excel" Mini-Tutorial
  6. Spreading The Word
  7. "Non-Excel" Tip
  8. Subscription Management

Click for an * Important Notice * to subscribers who haven't
been receiving my newsletters regularly in your email.


EDITOR NOTES Top

Hi Fellow Excel Addict,

Greetings from Newfoundland, Canada. I hope you're having a great week.

This week I've got some more tips that I hope will help make things easier for you.

I do want to ask for small favor. Do you know other Excel users who aren't getting my weekly tips? Do them a big favor and tell them about "Spreadsheet Tips From An Excel Addict." They will appreciate it and you'll be helping me spread my time-saving tips to the many Excel users who are also struggling day in and day out doing things the long, hard way.

Thanks for your help.

Have a great week.

To Your Success!
Francis Hayes (The Excel Addict)

P.S. Just another reminder that if you send me an email, make sure you include "TheExcelAddict" in the Subject line. That way, I won't accidentally delete it with all my other daily junk mail.


EXCEL "QUICK TIP" Top
The Seldom-Known, Seldom-Used AutoComplete Trick

If you're like me, it didn't take long after starting to use Excel to wonder if there is an easier way to repeat data in a column that you already have in previous cells in that column. The natural response is to copy and paste. But often that involves scrolling up the sheet to copy the data from previous cells and then scrolling back down to paste it.

Wouldn't it be great if you could just select an item previously used in that column from a list and have it automatically entered for you? Wouldn't that be cool?

Well you can!

Any time you want to repeat data that is already in a column, simply press ALT+DOWN ARROW. Just like magic, you've got an AutoComplete list of the previous entries in that column. Just use the arrow keys to select an item and press Enter.

Way cool!


EMPOWER AND IMPROVE Top
Over the past year I have discovered that in addition to increasing ones business knowledge and working on improving ones career it is equally important to work on improving ones self.

Jim Rohn says, "What you don't know WILL hurt you." I wish I had known this when I was younger. I can honestly say that, over the past two years, the wisdom of Jim Rohn has had a major positive affect on my life, both personally and in my business. If you are looking to improve yourself personally and/or professionally, Jim Rohn can help you just as he has helped millions of others around the world.

-- Personally recommended by Francis Hayes (The Excel Addict)

If you would like to benefit from the wisdom of 'America's Foremost Business Philosopher' check out his FREE weekly E-Zine.

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.


T-SHIRT CONTEST Top
Every month I am giving away a really cool t-shirt to one of my newsletter subscribers. You can sneak a peek at my t-shirt here.

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


"HOW TO EXCEL" MINI-TUTORIAL Top
Spice Up Your Worksheet With A Picture Or Two

Excel is not just for numbers. Did you know that you can add pictures to your Excel workbooks? It's easy!

  1. Select Insert, Picture, From File...
  2. Browse to the folder containing the picture you want to insert.
  3. Select the picture file and click the Insert button.
Wasn't that easy?

To move your picture just click and drag it.

To resize the picture, move the mouse over one of the corners of the picture and the cursor will change to a two-headed diagonal arrow. Hold down the left mouse button and drag it to the size you want.

Click here for more "How To Excel" Mini-Tutorials.

SPREADING THE WORD
Every week this newsletter is being read by Excel Addicts in: Albania, Antarctica, Antigua and Barbuda, Argentina, Australia, Bahrain, Brazil, Canada, Chile, China, Columbia, Costa Rica, Cote d'Ivoire, Croatia, Cuba, Cyprus, Denmark, Dominican Republic, Estonia, Finland, France, Germany, Great Britain, Guam, Hong Kong, Hungary, India, Indonesia, Ireland, Israel, Italy, Jamaica, Japan, Kazakhstan, Korea, Mexico, Nepal, New Zealand, Nigeria, Nicaragua, Norway, Pakistan, Peru, Philippines, Portugal, Romania, Saudi Arabia, Singapore, Slovenia, Spain, South Africa, Sweden, The Netherlands, Turkey, Uganda, Ukraine, United Arab Emirates, United States, Vanuatu, Venezuela, Viet Nam.

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.


BONUS "NON-EXCEL" TIP Top
Find That Missing Web Page
What do you do when you try to go to a web page but you get an error message saying the page is missing? Do you assume that the page doesn't exist anymore? Wrong answer!

The next time you get this 'HTTP 404 - File not found' error, a little investigative work will usually uncover the missing page for you. Most times pages are missing because a website has been reorganized and the page's address has been slightly changed. Here's a good example.

Up to a last month my November 12th 'Quick Tip' was located at "http://www.theexceladdict.com/quicktips/qtip054.htm". If you try to follow that link now, you won't find it because I recently reorganized my website - but the page is still there.

Start off by removing the last forward slash and everything to the right of it from the web address and try that link. If that takes you to a web page, check for links that may lead you to the page you are looking for. If you get another '404 Error', continue removing the next forward slash and everything to the right of it. Chances are you WILL find the page you are looking for.

Click here for more Bonus "Non-Excel" Tips

SUBSCRIPTION MANAGEMENT Top
This online version of Spreadsheet Tips From An Excel Addict is available only to subscribers of my free email newsletter. Each week, in addition to the email version of my newsletter, you will be emailed a special link to the online version. If you haven't subscribed yet you can click here to subscribe NOW or you can send a blank email to TheExcelAddict@DemandMail.com


Suggest tips to tips@TheExcelAddict.com Send testimonials to kudos@TheExcelAddict.com Send your suggestions for 'out-of-the-ordinary' uses for Excel to coolstuff@TheExcelAddict.com Any other comments send to francis@TheExcelAddict.com
"Spreadsheets Tips From An Excel Addict"
is a FREE weekly publication of TheExcelAddict.com.
Copyright © 2004, Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630