|
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: January 21, 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, I've always been someone who has never been satisfied with doing things a certain way just because "that's the way everyone else does it." I've learned over and over again during the past fifteen years that just about everything can be improved on, no matter how long people have been doing it. And you'll find no better vehicle to prove that point than Microsoft Excel. The fact that you have subscribed to, and are now reading, my newsletter tips, I believe you feel the same way too. It's great to find like-minded people with a desire to expand their knowledge. Many of the tips that I share with you will show you things you've never even thought. That's the whole point, isn't it? I want to help you expand your knowledge of Excel and help you use it to your benefit. However, to get the most benefit from these tips, it is important that you practice each of them, even if one doesn't seem to apply to what you do. If you take a few minutes each week to actually practice doing these tips and shortcuts, little by little, you'll see your productivity begin to soar. I promise. All I ask in return is for you to help me spread my newsletter by sharing it with your Excel friends and associates. So far my tips are now being read in more than 50 countries around the world. Wow! I hope you have a great week and enjoy these tips.
To Your Success! EXCEL "QUICK TIP" Top Easily Duplicate A Worksheet Many times you will need to create a workbook that is made up of two or more identical sheets. Many Excel users create each worksheet from scratch. Others, insert a new worksheet and copy and paste using the original worksheet. The problem with this is that the print settings have to be manually duplicated - which can often be tedious and frustrating. You can save yourself a lot of work by properly designing the first worksheet and then simply duplicating it (print settings and all) by holding down the CTRL key while dragging the sheet tab of the original. As you drag, you will notice a small sheet icon with a plus sign (indicating copying) and a small black arrow (indicating where the duplicated sheet will be inserted). Let up on the mouse button and CTRL key and you will have an identical copy of your original sheet.
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 How To Center Numbers And Still Keep Decimals Aligned Do you find yourself sometimes wanting to center your numbers in a column but when you do the decimals are not lined up? Here's a tip that I use anytime I need to perform such a task. The numbers aren't exactly centered but it gives the illusion that they are. Here's how:
SPREADING THE WORD Every week this newsletter is being read by Excel Addicts in: Albania, Antarctica, Antigua and Barbuda, Argentina, Australia, 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, 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 Start Your Internet Search Without Your Browser Open You're working away on your computer and decide you need to search for something on the Internet. Do you open your browser, click the Search button, and then type what you are searching for? Here's an even quicker way. Do you see the Address box on your taskbar? If not, right click an empty area on the taskbar and, from the pop-up menu, choose Toolbars and the Address. Adjust its size by dragging the left edge so it doesn't take up too much space. Now, whenever you want to search for something on the Internet, type your search term(s) in the Address box and hit Enter. Your browser will automatically open on a search page with your search results. This is one of those tips that can save you a little time each time you use it but as you add more of these to your computer knowledge, over time, they can really make a difference to your productivity and enjoyment of working with computers. I hope you like this one. It's one I always use.
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 | ||||