Navigation within Excel 2007 is accomplished by using the Ribbon. The Ribbon can be found at the top of Excel and is a significant change from other versions of Excel as it is the primary replacement for menus and toolbars.
Designed for easy navigation, the Ribbon consists of tabs that are organized around specific situations or objects. The controls on each tab are further broken down into similar like groups.
By default, Excel shows 7 tabs on the Ribbon. These are Home, Insert, Page Layout, Formulas, Data, Review and View.
There is also an 8th Ribbon labeled Developer that can be added by the user if required.
As you click on each Ribbon tab, the Ribbon will dynamically change.
Home tab - Contains the most common formatting and editing options.
Insert tab - Options to insert pictures, charts, headers, footers, and pivot tables.
Page Layout tab - Set margins, page orientation, gridlines, and heading options. Themes can also be found on this tab.
Formulas tab - Functions, formulas, auto sum options and name definitions.
Data tab – Allows you to get data from other sources such as Access and text files. Sorting, filtering and outline commands are also here.
Review tab – Contains the spell check, thesaurus, comments, and workbook /sheet protection options.
View tab – Options for workbook views including zoom and gridlines. Macros and the switch windows commands are also on this tab.
Developer tab – This tab can be added to the Ribbon is desired and has advanced controls used for Visual Basic and Macros.
To add the Developer tab, mouse click on the Office Button at the top left corner and then select Excel Options.
From the Excel Options dialog box, left mouse click on Show Developer tab in the Ribbon.
When done, select the OK button.