Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Finding Commands on the Excel 2007 Ribbon Tabs

The Ribbon in Microsoft Office Excel 2007 contains seven tabs. Contextual tabs also appear when you’re working with a particular object that you select in the worksheet, such as a graphic image, chart, or PivotTable. If you’re new to Excel 2007, take a few moments to become familiar with where the commands are located on the Ribbon tabs.

1

Click the Home tab.

The Home tab includes the command buttons normally used for creating, formatting, and editing a worksheet. The commands are arranged into the Clipboard, Font, Alignment, Number, Styles, Cells, and Editing groups.

2

Click the Insert tab.

You’ll find command buttons for adding particular elements to a worksheet (like graphics, PivotTables, charts, hyperlinks, and headers and footers) on the Insert tab. These commands are easy to locate in the Tables, Illustrations, Charts, Links, and Text groups.

3

Click the Page Layout tab.

When you’re ready to prepare a worksheet for printing, check out the commands on the Page Layout tab, arranged into the Themes, Page Setup, Scale to Fit, Sheet Options, and Arrange groups.

4

Click the Formulas tab.

The Formulas tab includes the command buttons normally used when adding formulas and functions to a worksheet or checking a worksheet for formula errors. This tab includes four groups: Function Library, Defined Names, Formula Auditing, and Calculation.

5

Click the Data tab.

When you want to work with data tools related to importing, querying, outlining, and subtotaling, check out the Data tab. You’ll find the commands arranged into the Get External Data, Connections, Sort & Filter, Data Tools, and Outline groups.

6

Click the Review tab.

The Review tab includes the command buttons normally used when proofing, protecting, and marking up a worksheet for review by others. This tab includes the Proofing, Comments, and Changes groups.

7

Click the View tab.

When you want to change the appearance of the Worksheet area and the data it contains, look for these commands on the View tab. You’ll find the Workbook Views, Show/Hide, Zoom, Window, and Macros groups on this tab.

   

In addition to these seven standard tabs, Excel has an eighth, optional Developer tab that you can add to the Ribbon if you do a lot of work with macros and XML files. To show the Developer tab, click the Office button, click Excel Options, and then select Show Developer Tab in the Ribbon.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.