Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

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!