Excel Ribbons

One of the greatest changes to Office 2007 is the introduction of ribbons rather than drop-down menus (really, you'll grow to love them). Click on an item in the ribbon bar (where it shows Home, Insert, Page Layout, etc.) to view the ribbon choices available under that item. 

If you want to quickly learn where a menu item has been replaced to, visit the Where'd It Go article. This article contains clickable clicks from Excel 2007 to the equivalent features in Excel 2007.

The following shows the various ribbons available:

Home Ribbon

The Home ribbon is also the primary formatting ribbon. Select this item to apply most text formatting choices.

Insert Ribbon

Use the Insert ribbon to.. insert things, such as pictures, tables, hyperlinks, text boxes, and other special items.

Page Layout Ribbon

Use the Page Layout ribbon to specify page details such as orientation, size etc. as well as other paragraph options.

Formulas Ribbon

Use the Formulas ribbon to insert formulas, manage named ranges, audit formulas and access calculation options (a great new addition to Excel 2007!).

Data Ribbon

Use the Data ribbon to access data controls such as links, sorting, filtering, validation, grouping, subtotaling and more.

Review Ribbon

Use the Review ribbon to access proofing options, comments and worksheet/workbook protection options.

View Ribbon

Use the View ribbon to select your document views, control window options and access Macro choices.

Developer Ribbon

Use the Developer ribbon to access more macro and code controls..

Keyboard Access to Ribbons

If you like keyboard access to ribbons and ribbon choices but do not want to memorize a million combinations, press the Alt key. You can then use the arrow keys to move through the ribbon displays. In the following illustration, the Alt key was pressed at the Insert ribbon. Note the letter access to each ribbon:


Additional References