I Command You

BY J. CARLTON COLLINS

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:

 

 Find us on Facebook      Follow us on Twitter

 

SPONSORED REPORT

How to audit high risk areas

Revenue recognition, internal control over financial reporting, accounting estimates and going concern are areas of audit that have emerged as particularly challenging and complex.

NEWS

Revenue recognition revisited

A reexamination of new revenue recognition rules has led to tinkering with the standard that is considered the biggest achievement of the convergence efforts of FASB and the International Accounting Standards Board.

INTERVIEW

Staying focused at the top

Olivia Kirtley, CPA, CGMA, an accomplished corporate director with almost 20 years of experience serving on boards, talks about strategic, risk, and compliance issues that keep board members up at night.