• Home
• Products
  Our Product List New Products Analysis Products Charting Products Data Products Downloadable Books Macro Products Specialty Products Time Saving Products Workbooks and Templates Products by Others Windows Products iPhone Applications
• Download
  Download Information Download Purchased Software Download Upgrades
• Support
  Support Top Support Questions Ordering FAQ's Money Back Guarantee Product FAQ's Online Meeting Excel Problems & Solutions How to Open and Use Excel add-ins How to repair Microsoft Excel
• Excel Solutions
  Charting Solutions Editing Solutions Formatting Solutions Formula Solutions Function Solutions Pivot Table Solutions Printing Solutions Selecting Solutions Toolbar and Menu Solutions Window Solutions Workbook Solutions Worksheet Solutions Other Solutions
• Company
  About Add-ins.com LLC How to contact us Contact Form Customer Feedback Policies License Agreement

How to find Excel ribbon commands
using the ribbon mapping workbook for Microsoft Excel

Excel users who have been using Excel 97 through Excel 2003 who upgrade to Excel 2007 or 2010 frequently find themselves lost and confused with the new Excel ribbon system.  For many users, the old menus were very easy to navigate, especially after years of use.  Both new and old Excel users are frustrated finding commands.  To help, Microsoft has a released a free workbook that maps Excel 97-2003 commands to the ribbon.

When you click on the download link found on the above page, a workbook will open in Excel.  Save this workbook to someplace that is easy to find!  The download link is actually to an Excel template.  You are not prompted to save the workbook as it opens automatically into Excel.  The following is a sample screen shot of one of the sheets in the workbook:

The following is a list of the sheets in the workbook:

To quickly navigate the many worksheets, you can use the Sheet Navigator, which displays a dialog that shows all the worksheets in a workbook for instant selection.

One thing you can do is to printout the workbook.  This is helpful, but finding the printout a few days later is always difficult.  A better approach is to open this workbook when you need it, search for a command, and close it.  To search, simply press CTL-F, Click on Options, change the search in box from worksheet to workbook (so all sheets are searched), type in a search word, and click Find.:

If you have the Spreadsheet Assistant, the first button on its toolbar opens your favorite files.  Just set up a bookmark in it and us it to open the ribbon mapping workbook whenever you need it.  And, the Spreadsheet Assistant adds back the classical Excel 97-2003 menus, which may be even more helpful than the ribbon mapping workbook!