Finding Excel 2007 Commands

by Allen Wyatt
(last updated September 28, 2015)

7

When you install Excel 2007 and use it for the first time, you may feel like you jumped overboard, without a life preserver, from the comfortable ship on which you were cruising. This is not unusual; Microsoft has changed just about everything in the old Excel interface. This can make it very difficult to find many of the commands you previously used with nary a second thought.

One thing you might find helpful is an Excel workbook that details where to find the old Excel 2003 commands in Excel 2007. Microsoft developed this to help ease the transition to the new software. You can find the workbook at the following link:

Command Workbook

Download the workbook to your system, and then open it. You'll find a worksheet tab for each of the Excel 2003 menus and toolbars, and each worksheet contains a list of the old commands from that menu or toolbar. To the right of these commands you'll find the way to accomplish the same task in Excel 2007.

The workbook can be opened either in Excel 2003 or Excel 2007.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6127) applies to Microsoft Excel 2007.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Understanding Sections

Sections are handy if you want to subdivide a document so you can apply different document formatting to those subdivisions. ...

Discover More

Inserting Symbols

Using the Character Map to insert symbols in Excel.

Discover More

Setting the Return Address Used in Word

When you create envelopes with Word, it normally displays a return address by default. If you can't get Word to retain the ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

MORE EXCELTIPS (RIBBON)

Changes in Excel's Color System

The introduction of Excel 2007 included the introduction of a lot of changes to the venerable spreadsheet program. One of ...

Discover More

Upgrading Your Personal Workbook

When you upgrade to Excel 2007, you may wonder if you also have to upgrade to the new format for your Personal workbook. The ...

Discover More

Upgrading Personal.xls to Excel 2007

When upgrading to Excel 2007, you may wonder how you can convert your older Personal.xls file to something that can be used ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 7?

2013-03-13 18:48:19

Bob Davey

This is in addition to Henry's contribution.

You can also restore much of your Personal.xls 2003 content and the 2003 toolbars themselves using Ron de Bruin's Myaddin for 2007. Couple this with Jon Walkenbach's faceid addin and you can have the best of both worlds. These are freebies.

The MS workbook link did indded work but I personally found the content to be just as confusing as 2007 itself.


2013-03-13 18:21:37

Craig M

For interactive guides for Excel 2010 (& other MS 2010 programs), go to:

http://office.microsoft.com/en-au/outlook-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-and-related-products-HA101794130.aspx?CTT=3


2013-03-13 13:33:28

Stube

I thought this tip would give a list of 2003 commands, when in fact it gives the new location for the functionality. My definition of a command is for example, "Ctrl+E L" to delete a sheet in a workbook. I think these are called shortcuts by some people. Would be useful to have a list of 2003 shortcuts.


2013-03-13 09:31:35

Henry Noble

If you are one of the many who prefer menus to ribbons, take a look at Classic Menu for Office, by Addintools. It gives you menus and toolbars like those in Office 2003, so little re-learning or re-training is required. The ribbon remains only a click away for use when that is the better tool.

There are versions for Office 2007/2010/2013 and for the different suites within those model years.

For me, the productivity increase was worth every penny of the add-in's cost.


2013-03-13 08:42:12

Donald

Great resource but typical of Excel users to separate data by worksheets instead of using filters. Add a columns and place the worksheet name in the new column for each row. Place all of the records in one worksheet. Then use a filter if you want to see the date by worksheet name. You could also Group by the new column. Benefit is you can see all the commands, sort or search for the one you are looking for with out having to know where it was previously located.


2013-03-13 08:04:47

Chris Coleman

"This tip (6127) applies to MS Excel versions: 2007"
Does this tip (and all other ribbon interface tips) also apply to 2010 and 2013? Or not? How can I tell, other than by trying them out?


2013-01-03 07:34:10

Bill

The link to "Command Workbook" failed.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing