Spreadsheet Tips From An Excel Addict Helping Average Spreadsheet Users Become Local Spreadsheet Experts A Free Weekly Publication of TheExcelAddict.com   Publication Date: July 19, 2006 This newsletter is sent only to those who have requested it. If you didn't request this, see the simple instructions at the bottom of this newsletter. THIS WEEK'S QUOTE: "Learn to enjoy every minute of your life. Be happy now. Don't wait for something outside of yourself to make you happy in the future. Think how really precious is the time you have to spend, whether it's at work or with your family. Every minute should be enjoyed and savored." -- Earl Nightingale   GREETINGS FROM CANADA   Hi fellow Excel Addict,   As promised, my tips will keep coming with no interruption, not even for my vacation. After all, I am an Excel ADDICT!   The response to my Excel Addict Challenge last week was overwhelming -- and a little humbling. After using Excel for almost 15 years, I hadn't discovered the SHIFT + Find Next trick for searching BACKWARDS in a worksheet, but approximately 40% of my readers who wrote me knew about it.   So, the answer to my Excel Addict Challenge last week was: To search backwards using the Find feature you simply hold down the SHIFT key while clicking the Find Next button.   As I did not specify in my challenge that Gail was looking for a pre-XL2003 solution, I also got many correct answers for searching backwards in XL2003 by starting from the bottom of the results list.   I really enjoyed doing this challenge. I think I may make this a regular feature, maybe monthly. Maybe a little more challenging? What do you think?   I hope you find something in this week's newsletter that will help make your work in Excel easier, faster, more enjoyable or preferrably all three.   To your success, Francis J Hayes (The Excel Addict)     This weeks tips... Really? I Can Right-Click With My Keyboard?! Moving Within A Selected Range Of Cells Downloading Audio Files From The Web Last weeks tips... Quickly Select A Large Table or Long List Maintenance Free Subtotals On Your Reports Quickly Selecting Items In A List   You can still get them here. You can access my archive of tips on my website by going to http://www.theexceladdict.com/members.htm. Please remember to include "TheExcelAddict" in the Subject line of any emails you send to me at fhayes(AT)theexceladdict(DOT)com. This will help your email stand out in the flood of junk email I receive daily. You can help! Do you know other Excel users who would benefit from these tips? Go ahead, email this newsletter right now to the ones you know. As you know, I really love using Excel and sharing my tips with everyone who can benefit from them. My goal is to have my weekly tips going out to 1,000,000 Excel users all around the world. I would really appreciate it if you could help me reach this goal by sharing this newsletter with all of your 'Excel-loving' friends and colleagues. You will be helping me and also everyone you share my tips with. Thanks in advance for your support. Francis J 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 Looking to take your Excel skills to the next level? Check out... EXCEL "QUICK TIP" Really? I Can Right-Click With My Keyboard?! As you know, I am always preaching the benefits of knowing both a mouse method and a keyboard method for doing your most common tasks in Excel. So you may be asking, "How can I access the shortcut (right-click) menu when I am in 'keyboard mode'?" The answer is right under your nose. Look at your keyboard. See that rarely-used, no-one-knows-what-it's-for key next to the Ctrl key (on most PC keyboards)? It looks like a dropdown menu with an arrow pointer. That is the 'Application key'. Pressing this key will display the selected item's shortcut menu the same as you get when you right-click. Once the shortcut menu is displayed, use the arrow keys to move through the options and the right arrow key to select sub-menus. Press the Enter key to execute the command. Know an even better way? Let me know at fhayes(AT)theexceladdict(DOT)com Click here for more Excel "Quick Tips". Simplify your daily office tasks! PowerPlugs: Excel Solutions for Office Managers is a collection of professional office forms and spreadsheets. There are 21 useful forms. All conveniently work inside Microsoft Excel. They are designed to simplify your daily office tasks and help you run your business more smoothly. Take a look here!   "HOW TO EXCEL" MINI-TUTORIAL Moving Within A Selected Range Of Cells Often when you have a range of cells selected, you need move the active cell within the range without deselecting the range. Here are some keyboard shortcuts you can use to get the active cell to move in whichever direction you like. Enter - moves the active cell one cell down Shift+Enter - moves the active cell one cell up Tab - moves the active cell one cell to the right Shift+Tab - moves the active cell one cell to the left CTRL + (period) - moves the active cell from corner to corner within the selected range Now, at first glance, these shortcuts may not look all that interesting, but I always say, 'you need to practice the tip before you can appreciate if it is something that will help you.' Just take a minute to practice moving the active cell around a selected range using the above keyboard shortcuts. If you are entering data, you press the keyboard shortcut at the point you would normally press the Enter key. You may not need to use this tip every day, but there will be times when this will come in handy. Know an even better way? Let me know at fhayes(AT)theexceladdict(DOT)com Click here for more "How To Excel" Mini-Tutorials. EXCEL ADDICTS AROUND THE WORLD Every week this newsletter is being read by Excel Addicts in 100 countries: Albania, Anguilla, Antarctica, Antigua and Barbuda, Argentina, Aruba, Australia, Austria, Azerbaijan, Bahrain, Barbados, Belgium, Bosnia and Herzegowina, Brazil, Canada, Cayman Islands, Chile, China, Colombia, Costa Rica, Cote d'Ivoire, Croatia, Cuba, Cyprus, Czech Republic, Denmark, Dominican Republic, Ecuador, Egypt, El Salvador, Estonia, Finland, France, Germany, Ghana, Greece, Guam, Hong Kong, Hungary, India, Indonesia, Iran, Ireland, Israel, Italy, Jamaica, Japan, Kazakhstan, Korea, Kuwait, Lebanon, Macau, Macedonia, Malaysia, Mali, Malta, Mexico, Nepal, The Netherlands, New Zealand, Nicaragua, Nigeria, Norway, Oman, Pakistan, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Puerto Rico, Qatar, Reunion, Romania, Saudi Arabia, Singapore, Slovenia, South Africa, Spain, Sri Lanka, Sweden, Switzerland, Tajikistan, Tanzania, Thailand, Trinidad and Tobago, Turkey, Uganda, Ukraine, United Arab Emirates, United Kingdom, United States, Uzbekistan, Vanuatu, Venezuela, Viet Nam, Yugoslavia, Zambia, Zimbabwe. 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... "Spreadsheet Tips From An Excel Addict". BONUS "NON-EXCEL" TIP Downloading Audio Files From The Web Do you frequently listen to audio files on the Internet? Have you ever wished that you could download and save these files to your computer so you could listen to them at another time or even to burn to a CD or save to your MP3 player? If you answered yes to both of those questions you probably know that most audio files on the Internet cannot be downloaded and saved. They can be played only while you're at the website. That hasn't stopped me though. There is so much valuable information on the web, much of it is contained in audio files, and I don't want to be confined to my computer for long periods of time just so I could listen to an audio. I've discovered a freeware program that allows you to record audio files as they are playing on your computer. You can then save them and listen to them at another time. I can now burn these files to CDs and listen to them while I'm driving, working out at the gym or whenever it is convenient for me. I'm big on personal development and I've found lots of fre e audio files available all over the Internet. This program allows me to easily save and edit these files. If you have been wishing you could save audio files from the Internet, you can download Audacity at http://audacity.sourceforge.net/ Audacity is a free, open source software for recording and editing sounds. It is available for Mac OS X, Microsoft Windows, GNU/Linux, and other operating systems.   While Audacity is free, I personally have chosen to invest a few dollars and purchase a very easy-to-use program called Polderbits Sound Recorder and Editor. It has a very simple interface that allows you to easily and simply record, edit and save any sound that you can play through your computer's speakers. I love it! If you also have an interest in personal development, I'd love to share some of the sources I use personally. Just send me an email. Know an even better way? Let me know at fhayes(AT)theexceladdict(DOT)com Click here for more "Non-Excel" Tips. SUBSCRIPTION MANAGEMENT Spreadsheet Tips From An Excel Addict is available only to subscribers of my free email newsletter. If this newsletter was forwarded to you and you would like to get your own subscription, please send a blank email to TheExcelAddict(AT)Aweber(DOT)com "Spreadsheets Tips From An Excel Addict" is a FREE weekly publication of TheExcelAddict.com. Copyright Francis J. Hayes All Rights Reserved. 8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630