If you think the ribbon is taking up too much of your window space you can minimize it so that it only displays the tab names.
Minimize the Ribbon by Unpinning it
The ribbon can be minimized by right-clicking anywhere on the ribbon and selecting Unpin the Ribbon.
|
|
The ribbon can also be minimized by clicking on the up arrow at the far right end of the ribbon. Moving the cursor over the button shows a tool tip.
The ribbon remains fully functional when it is unpinned. Clicking on one of the tabs expands the Ribbon to its full view.
The ribbon will return to its minimized state after you click on one of the commands on the ribbon. It will also return to a
minimized state if you click on any cell in the worksheet.
Restore the Ribbon to its Full State by Pinning it
If you click on one of the tabs when the ribbon is unpinned you will see a pin
at the far right end of the
ribbon. Clicking on the pin will return the ribbon to a pinned state. The ribbon can also be returned to its pinned state by
right-clicking anywhere on the ribbon and then selecting Unpin the ribbon; this will remove the check mark in front of it.
Shortcut key for Pinning and Unpinning the ribbon.
Pressing Ctrl + F1 works like a toggle switch for unpinning
and pinning the ribbon.
Practice for Minimizing the Ribbon
- You can collapse the ribbon to gain more space for your spreadsheet. Right-Click on the ribbon and select Unpin the ribbon.
The tabs are displayed without any groups.
- Click on one of the ribbon tabs. The groups appear. Click on any cell in the worksheet to make the groups disappear.
- Right-click on the ribbon. The menu shows that the Unpin the ribbon option is currently active (it has a check mark in front of it). Click on Unpin the ribbon. The Ribbon returns to a full display.
- Click on the Unpin the ribbon button
at the far right end of the ribbon.
- Click on the Pin the ribbon button
at the far right end of the ribbon.
- Press Ctrl + F1. The ribbon is unpinned.
- Press Ctrl + F1. The ribbon is pinned.