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!

View Cart

Quantity
Discounts

Order online
Immediate
delivery

Money back
guarantee.