This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Find Icons on the Ribbon
Problem: The new ribbon user interface might be great for people new to Excel, but I knew the old Excel perfectly well. Why did Microsoft put pivot tables on the Insert tab instead of the Data tab, where they belong?
Strategy: The transition does not take that long, you follow a few basic rules.
Here are some simple guidelines:
● The Home tab contains the most frequently used commands. If you want to find something, start looking on the Home tab. Nearly everything from the Excel 2003 Edit and Format menus is located on the Home tab. Everything from the Excel 2003 Formatting toolbar is on the Home tab.
● The most-used commands on the Excel 2003 Insert menu are not on the Insert tab in Excel 2010! Instead, commands to insert cells, rows, columns, and worksheets are on an Insert drop-down on the Home tab. Commands to insert a function or a name are on the Formulas tab. Insert Comment is on the Review tab.
● The Pivot Tables command has been moved from the Data menu to the left side of the Insert tab.
● Most Excel 2003 File menu commands are on the Excel 2010 File tab. This tab is called the Backstage view and is discussed in detail later. A few File commands are elsewhere. For example, Save Workspace is on the View tab. Page Setup and Print Area are on the Page Layout tab. In Excel 2007, the File menu is behind the Office decoration in the top left corner of the screen.
● Everything on the old Window menu and most things from the old View menu are now on the View tab.
● Help is now the blue question mark icon at the top right of the window. Everything else that used to be on the Help menu is now under File, Help. Except Clippy. Clippy has retired.
● Items from the Data menu are generally on the Data tab, with the exception of the Pivot Tables command.
● The old Tools menu has been split among many tabs. You will find these commands spread among the Review, Formulas, Home, Data, View, and File tabs.
Microsoft does not provide a classic mode, but third party companies do. Check out the Classic Excel Menu from AddInTools.com or Toolbar Toggle.
With both of these add-ins, you can work in the Excel 2003 menu, and then switch over to the ribbon menu when you need to access new features.