Microsoft Office Tutorials and References
In Depth Information
Excel provides three types of tabs on the Ribbon. The first type is called a standard
tab—such as File, Home, Insert, Page layout, Formulas, Data, Review, View, and Add-
Ins—that you see whenever you start Excel. The second type is called a contextual
tab—such as Picture Tools, Drawing, or Table—that appears only when they are needed
based on the type of task you are doing. Excel recognizes what you’re doing and provides
the right set of tabs and tools to use when you need them. The third type is called a pro-
gram tab that replaces the standard set of tabs when you switch to certain views or modes.
When you point to a gallery option, such as WordArt, on the Ribbon, Excel displays a live
preview of the option change so that you can see what your change will look like before
selecting it. The Paste Options button also displays a live preview for pasted content.
If you want more display screen, you can collapse and expand the Ribbon as you need it.
Click the Ribbon Display Options button ( New ! ) to select an option: Auto-hide Ribbon,
Show Tabs, or Show Tabs and Commands. Auto-hide Ribbon collapses the Ribbon until
you click the top of the program. Show Tabs displays only tabs until you click a tab to
show it. Show Tabs and Commands displays the Ribbon all the time.
To collapse the Ribbon, click the Collapse the Ribbon button (Ctrl+F1)
or double-click the current tab. Click a tab to auto display it (Ribbon re-
mains collapsed). To expand the Ribbon, press Ctrl+F1 or double-click