Microsoft Office Tutorials and References
In Depth Information
Shrinking the Ribbon
Sometimes, a command truly is not in the ribbon. If you hover over a
command in the Customize dialog and the tooltip indicates that this is
a command that is not in the ribbon, you have to use Customize to add
this command to the Quick Access Toolbar or to the ribbon.
Shrinking the Ribbon
The ribbon does take up four vertical rows of space. This won t be an issue
on a big monitor, but it could be an issue on a tiny netbook.
Starting in Excel 2013, to shrink the ribbon, you can right-click the ribbon
and choose Collapse the Ribbon. The ribbon collapses to show only the rib-
bon tabs. When you click a tab, the ribbon temporarily expands. To close the
ribbon, choose a command or press Esc.
Starting in Excel 2013, the ribbon often stays open after certain com-
mands. For example, I frequently click the Increase Decimal icon three
times in a row. When the ribbon is minimized, you can click Home and then
click Increase Decimal three times without having the ribbon close.
To permanently bring the ribbon back to full size, right-click a ribbon tab
and uncheck Collapse the Ribbon.
Note that you can also minimize the ribbon using the carat (^) icon at the bot-
tom right of the expanded ribbon. To expand the ribbon, click any tab and then
click the pushpin icon in the lower-right corner of the ribbon.
Using the Quick Access Toolbar
A problem with the ribbon is that only one-seventh of the commands are vis-
ible at any given time. You will find yourself moving from one tab to another.
The alternative is to use the Quick Access Toolbar (QAT) to store your fa-
vorite commands.
The QAT starts out as a tiny toolbar with Save, Undo, and Redo. It is ini-
tially located above the File tab in the ribbon.
Search JabSto ::

Custom Search