Finding Commands in Excel 2007

Summary: Excel 2007 introduced a radically new user interface that does away with the traditional program menus. If you knew where some commands were in Excel, this can make finding them in Excel 2007 a challenge. Here's a tip on a handy workbook you can use to make finding commands much easier in the new interface. (This tip works with Microsoft Excel 2007.)

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 this URL:

http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033

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 (3142) applies to Microsoft Excel versions: 2007

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.

Check out ExcelTips: Times and Dates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Finding Commands in Excel 2007