Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
✓ Review tab with the command buttons normally used when proofing,
protecting, and marking up a spreadsheet for review by others, arranged
into the Proofing, Language, Comments, and Changes groups. Note:
This tab also contains an Ink group with a sole Start Inking button when
you’re running Office 2013 on a device with a touchscreen such as a
Tablet PC or a computer equipped with a digital ink tablet.
✓ View tab with the command buttons normally used when changing the
display of the Worksheet area and the data it contains, arranged into the
Workbook Views, Show, Zoom, Window, and Macros groups.
In addition to these standard seven 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. See Chapter 12 for more on the Developer tab. If you
are running a version of Excel 2013 with the PowerPivot add-in installed, a
PowerPivot tab appears near the end of the Ribbon.
Although these standard tabs are the ones you always see on the Ribbon
when it’s displayed in Excel, they aren’t the only things that can appear in
this area. Excel can display contextual tools when you’re working with a
particular object that you select in the worksheet, such as a graphic image
you’ve added or a chart or PivotTable you’ve created. The name of the
contextual tool for the selected object appears immediately above the tab or
tabs associated with the tools.
For example, Figure 1-5 shows a worksheet after you click the embedded
chart to select it. As you can see, doing this adds the contextual tool called
Chart Tools to the very end of the Ribbon. The Chart Tools contextual tool
has its two tabs: Design (selected) and Format. Note, too, that the command
buttons on the Design tab are arranged into the groups Chart Layouts, Chart
Styles, Data, Type, and Location.
The moment you deselect the object (usually by clicking somewhere outside
the object’s boundaries), the contextual tool for that object and all its tabs
immediately disappear from the Ribbon, leaving only the regular tabs —
Home, Insert, Page Layout, Formulas, Data, Review, and View — displayed.
Selecting commands with mouse and keyboard
Because Excel 2013 runs on many different types of devices, the most
efficient means of selecting Ribbon commands depends not only on the device
on which you’re running the program, but also on the way that device is