Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
When you work in Excel with the Ribbon collapsed, the Ribbon expands each
time you activate one of its tabs to show its command buttons, but that tab
stays open only until you select one of the command buttons or select an
element in the worksheet. The moment you select a command button, Excel
immediately minimizes the Ribbon again and just displays its tabs. Note that
you can also use the Show Tabs and Show Tabs and Commands options on
the Ribbon Display Options button’s drop-down menu to switch between
collapsing the Ribbon to its tabs and restoring its commands again.
Keeping tabs on the Ribbon
The first time you launch a new workbook in Excel 2013, its Ribbon contains
the following tabs from left to right:
✓ Home tab with the command buttons normally used when creating,
formatting, and editing a spreadsheet, arranged into the Clipboard, Font,
Alignment, Number, Styles, Cells, and Editing groups.
✓ Insert tab with the command buttons normally used when adding
particular elements (including graphics, PivotTables, charts, hyperlinks,
and headers and footers) to a spreadsheet, arranged into the Tables,
Illustrations, Apps, Charts, Reports, Sparklines, Filter, Links, Text, and
✓ Page Layout tab with the command buttons normally used when
preparing a spreadsheet for printing or re-ordering graphics on the sheet,
arranged into the Themes, Page Setup, Scale to Fit, Sheet Options, and
✓ Formulas tab with the command buttons normally used when adding
formulas and functions to a spreadsheet or checking a worksheet for
formula errors, arranged into the Function Library, Defined Names,
Formula Auditing, and Calculation groups. Note: This tab also contains
a Solutions group when you activate certain add-in programs, such as
Analysis ToolPak and Euro Currency Tools. See Chapter 12 for more on
using Excel add-in programs.
✓ Data tab with the command buttons normally used when importing,
querying, outlining, and subtotaling the data placed into a worksheet’s
data list, arranged into the Get External Data, Connections, Sort & Filter,
Data Tools, and Outline groups. Note: This tab also contains an Analysis
group when you activate add-ins, such as Analysis ToolPak and Solver.
See Chapter 12 for more on Excel add-ins.