|
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
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!
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!
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.
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.
"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!
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.
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.
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 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 | ||||