Spreadsheet Tips From An Excel Addict Helping Average Spreadsheet Users Become Local Spreadsheet Experts A Free Weekly Publication of TheExcelAddict.com   Publication Date: July 5, 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: "Don't say you don't have enough time. You have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein." -- H. Jackson Brown GREETINGS FROM CANADA   Hi fellow Excel Addict,   Well, summer is into full swing here in Newfoundland. The kids are out of school and for the first time in years I get to relax and watch my daughter play soccer (football) as a spectator rather than a coach. This is the first time in 8 years that I haven't coached a soccer team. I sometimes miss coaching but it sure frees up a lot of time for me to do other things. My garden hasn't looked better in years.   So have you been watching the World Cup? Because I live in Canada, I'm usually at work when the games are on live, but I usually catch the last 1/2 hour of the game when I get home. For the most part the games I've seen have been great. What a finish yesterday with Italy and Germany. I was hoping Germany would win because the home team in the final would have been something to watch. I'll miss most of today's game between France and Portugal but I definitely won't miss the FINAL on Sunday.   Anyway, enough about soccer. Let's get to the tips.   To your success, Francis J Hayes (The Excel Addict)     This weeks tips... Display Your Numbers As Thousands Sorting Sideways Keep Your Quick Launch Bar Uncluttered Last weeks tips... Using A Data Validation List From Another Sheet Custom Menu Access To Frequently Used Workbooks Put An End Long Lines In Email Messages 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. You can still get them . You can access my archive of tips on my website by going to . 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" Display Your Numbers As Thousands A while ago I showed you how you could round your numbers to the nearest thousand using the ROUND function. If, instead, you would like to have your numbers just displayed as thousands without changing the actual cell value, you can do that too with number formatting. Select the cells you want to format as thousands. Click Format, Cells, select the Number tab, click Custom, type 0, (zero comma) in the Type field and click OK. 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 Sorting Sideways Excel's default setting for sorting is by row. However, sometime you may want to sort by column instead. Here's how... Select the range of data you want to sort. From the menu select Data, Sort Click the Options button From the Sort Options dialog, select Sort Left To Right and click OK The first Sort by option uses the first row by default, however, you can sort by any row in the selection. Choose Ascending or Descending Click OK It is always a good practice to save your work before you sort. You can Undo after the sort but if you mess things up, you can really cause yourself a lot of grief. Sometimes, making a backup copy of your workbook is a good idea because it may be days later before you realize you messed up. Another important thing to remember about sorting is, if you have a range of cells selected, Excel will sort only the data in those selected cells. You can allow Excel to select the sort range by selecting only one cell anywhere in that range. Excel will expand the sort range to all cells in the current region (bounded by blank columns and rows or the edges of the worksheet). To be sure that you sort only the range you want, I suggest that you select the sort range yourself. 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 Keep Your Quick Launch Bar Uncluttered In previous tips you've heard me recommend using the Quick Launch bar on your Task Bar as an easy and fast way to launch your most frequently used programs and files. Unfortunately, as you install more and more software on your computer, some programs will automatically add a shortcut icons to your Quick Launch bar. If you find that you rarely use some of these shortcuts, the simple solution is to right-click and delete them off your Quick Launch bar. Remember, these are just shortcuts. When you delete a shortcut, it doesn't affect the program itself. You will still have access to these programs through the Start, Programs menu.   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