Q: I recently upgraded to Excel 2007, and I can’t seem to find all of the same commands I used in Excel 2003, such as the ability to e-mail a single worksheet or pivot multiple ranges of data. Why did Microsoft get rid of some of Excel 2003’s commands, and are there any good work-arounds for these missing capabilities?
A: The missing functionality you mention is still in Excel 2007 and 2010, but it is hidden. When Microsoft redesigned the menus for Excel 2007 and 2010, it excluded 219 commands from the newer menu Ribbon. To view a complete list of these hidden commands follow these steps: Start by right-clicking on the Quick Access Toolbar and choosing the option to Customize Quick Access Toolbar….
Next, in the Choose commands from dropdown menu, select the option to view Commands Not in the Ribbon.
This action will display the list of 219 commands not included in the Ribbon on the left side of the dialog box, and those commands that are included in your Quick Access Toolbar on the right side of the dialog box.
To access the hidden commands, you must first add them to your Quick Access Toolbar by highlighting the desired command in the left column, and clicking the Add>> button to include it in the right column. Hit OK when done. Many of the hidden tools are obscure and seldom used, however some are among my favorites. The seven Excel 2003 commands that are most notably missing from the Excel 2007 and 2010 menu Ribbon are shown below:
While the particular commands you choose to add to your Quick Access Toolbar will depend on personal preference, I recommend adding the above-mentioned commands to your Quick Access Toolbar, as well as the following 20 commands that I personally find useful, to make them easily accessible:
Note: A few Excel 2003 capabilities have disappeared from Excel 2007 and 2010. For example, you can no longer publish Web pages in an interactive format. (The interactive format command in Excel 2003 allows you to publish HTML pages in which readers can input data directly via the browser). Also, embedded video clips and sound clips no longer play as embedded objects in Excel 2007 and 2010; instead, those clips are played in the computer’s default media player application.
More from the JofA: