Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
This site is designed primarily for users of Excel 97 (version 8), Excel 2000 (version 9), Excel 2002 (version 10) and Excel 2003 (version 11). You will find some tips for Excel 2007 (version 12), but we are slowly moving all those tips to our ribbon-based ExcelTips site. When there are differences in how a certain tip is done on a particular version of Excel, those differences are clearly explained in each tip.
Many ExcelTips are equally applicable to versions of Excel for the Mac. In fact, there are many newsletter subscribers who use only Excel for the Mac. The differences in implementation for the Mac are not pointed out in ExcelTips, however. In addition, I don't point out the basic usage differences between Windows and Mac systems, such as holding down the Ctrl key as you click the mouse to simulate a right-click.
There is one other thing to keep in mind for those using Excel 2004 for the Mac: This particular version of Excel does not include support for VBA. This means that none of the macros detalied on this site will work for you. There is only a single recourse—update to a later version of Excel which does include VBA support. (Microsoft was roundly criticized for not including the support in Excel 2004 for the Mac.)
No. The information on this site and the information in the ExcelTips newsletters is provided free of charge. We do, however, have a subscription-based version called ExcelTips Premium. It provides many benefits over regular ExcelTips, and is available for a nominal annual charge.
The ExcelTips newsletters are published each Saturday, before the end of the day. For many readers, this means that ExcelTips is waiting for them when they arrive at work on Monday morning.
ExcelTips is written and edited by Allen L. Wyatt.
For two reason, primarily. First, I use Excel quite often, and I really enjoy the program. That being said, there are still many things that are frustrating, and I have had to search for how to accomplish them. I think many other people are in the same boat. The second reason is that I love to write. I have written about 50 computer books (type my name into Amazon) and you have to love writing to do that.
ExcelTips is not a tutorial in how to write macros, but many of the tips included in ExcelTips rely on macros to accomplish tasks.
Each ExcelTips newsletter includes a Help Wanted section. The section is dedicated to those readers having problems making Excel behave the way they expect. It contains restated problems that were forwarded to ExcelTips. If you have a problem, visit this page to send it in. We can't guarantee you will get a prompt answer (or even an answer at all), but you may be able to finally get that nagging problem off your chest. If your question is included in the Help Wanted section, readers may respond with solutions. These solutions are then formatted into tips which appear in future issues of ExcelTips.
Yes, you can—to a point. We want people to hear about and use ExcelTips. ExcelTips may be circulated via MANUAL forwarding by e-mail to others, providing that 1) the file is transmitted in its entirety, and 2) NO FEE is charged. We would ask that you only do this to the same person up to three times. At that point, your friend should have decided whether to subscribe on their own. (After all, ExcelTips is free and anyone can get it.)
If you subscribe to ExcelTips Premium, weekly issues of that newsletter may not be passed on to others or shared with them.
Please invite your friends to visit the ExcelTips Web site. Thousands of people search through the answers there and get the help they need. It is a great place for people to get a feel for the quality of the newsletter's content and to make their own decisions.
Yes, as long as each issue is included with no alterations. People on the network must be able to subscribe on their own, as well. Note that this posting must not be accessible to anyone outside of your organization. This means you cannot post ExcelTips on your Web site, your FTP site, or your BBS. You cannot copy information from the ExcelTips Web site and post it to your network, although we encourage links to the Web site itself.
Yes; no problems there. Please feel free to link as much as you would like.
Simple—just use the subscription form at the right side of any page on this site, including this page.
There is a link at the bottom of any issue of ExcelTips.
Again, use the link at the bottom of any issue of ExcelTips.
ExcelTips allows some advertising in the newsletter. If you would like to help support ExcelTips and promote your products or services, we have prepared another Web page with more information.