Microsoft Office Tutorials and References
In Depth Information
bar has a control named Ribbon Display Options (next to the Help button). Click the control
and choose one of three Ribbon options: Auto-hide Ribbon, Show Tabs, or Show Tabs and
The commands available in the Ribbon vary, depending upon which tab is selected. The
Ribbon is arranged into groups of related commands. Here’s a quick overview of Excel’s tabs:
Home: You’fill probably spend most of your time with the Home tab selected. This
tab contains the basic Clipboard commands, formatting commands, style
commands, commands to insert and delete rows or columns, plus an assortment of
worksheet editing commands.
Insert: Select this tab when you need to insert something in a worksheet — a
table, a diagram, a chart, a symbol, and so on.
Page Layout: This tab contains commands that affect the overall appearance of
your worksheet, including some settings that deal with printing.
Formulas: Use this tab to insert a formula, name a cell or a range, access the
formula auditing tools, or control how Excel performs calculations.
Data: Excel’s data-related commands are on this tab, including data validation
Review: This tab contains tools to check spelling, translate words, add comments,
or protect sheets.
View: The View tab contains commands that control various aspects of how a sheet
is viewed. Some commands on this tab are also available in the status bar.
Developer: This tab isn’t visible by default. It contains commands that are
useful for programmers. To display the Developer tab, choose File
Options and then
select Customize Ribbon. In the Customize the Ribbon section on the right, make
sure Main Tabs is selected in the drop-down control, and place a check mark next
■ Add-Ins: This tab is visible only if you loaded an older workbook or add-in that
customizes the menu or toolbars. Because menus and toolbars are no longer
available in Excel 2013, these user interface customizations appear on the Add-Ins tab.
The preceding list contains the standard Ribbon tabs. Excel may display additional Ribbon
tabs, resulting from add-ins or macros.
The File tab doesn’t offer a bar of commands like the other Ribbon tabs. Clicking the File tab displays a different
screen (known as Backstage view), where you perform actions with your documents. This screen has commands
along the left side. To exit the Backstage view, click the back arrow button in the upper-left corner.