Buzz
Ribbon in Excel 2016 serves as a tool to assist users in executing command operations to utilize features available in Excel 2016. The Ribbon contains commands as well as groups of commands called command groups. These command groups and other individual commands will be organized into different tabs. Of course, you can personalize the Ribbon to arrange tabs and commands according to your preferences. This article below will guide you on how to set up Ribbon in Excel 2016.
SETTING UP RIBBON IN EXCEL 2016
You can download Office 2016 to your computer via the following link: Download Office 2016
Ribbon Display Options
You can find the icon for Ribbon display options at the top right of Excel. Here, you have options to choose from Auto - Hide Ribbon, Show Tabs, and Show Tabs and Commands.
- Auto - Hide Ribbon: This customization option will hide all tabs, commands, and the entire Ribbon, displaying only the formula bar, name box, and basic spreadsheet. To show the Ribbon again, hover your mouse over the top right or simply click on the top of the spreadsheet.
- Show Tabs: This customization option hides command groups and commands, showing only Ribbon tabs. You can click on a tab to display the commands within it.
- Show Tabs and Commands: This customization option will restore all tabs, command groups, and commands to their default display as initially shown.
Hide Ribbon
If you prefer not to display the Ribbon or want your spreadsheet to have more space, you can easily hide it. Simply click on the upward arrow icon at the top right of the spreadsheet, or use the shortcut Ctrl + F1 to execute.
You can pin the content of any tab you want to display when hiding the Ribbon by following these steps:
- Click on a tab you want to display
- Click on the pin icon or use the shortcut Ctrl + F1 to pin the display content of the tab.
Customize Tab and Commands on the Ribbon
You can customize tabs and commands on the Ribbon as you wish, such as changing their positions, renaming, adding, removing, or hiding them.
Customize Tab
To open the tab customization box, go to File => Options => Customize Ribbon or right-click anywhere on the Ribbon and select Customize the Ribbon... The Customize Tab interface appears, with all commands on the left and Tabs and command groups on the right.
Here, there are plenty of options to customize tabs that you can see.
- Tab Arrangement: To rearrange Tabs, click on the up-down arrow icon and choose the position where the Tabs appear before or after.
- Add New Tab: To add a new Tab, click on New Tab, and a New Tab will immediately appear.
- Add New Command Group: To add a new command group, select any Tab, then click on New Group, and a new command group will immediately appear below that tab.
- Rename Tab, Command Group: To rename a tab, command group, select a tab, or command group you want to rename, then click on Rename and set the name for that tab or command group.
- Delete Tab, Command Group: Select a Tab, command group you want to delete, then right-click and choose Remove.
- Hide or Show a tab, group: Deselect the tab or group you want to hide and vice versa.
- Add a new command: Select the command you want to add as well as select the tab, group to add to then click Add to complete.
- Delete a previously added command: To delete a previously added command, select that command in the Tab table and click Remove to delete it.
Furthermore, if you wish to restore default settings for the Ribbon, you can click on Reset => Reset all customizations...
Sharing Ribbon with Others
Another interesting point is that you can share your customized Ribbon with friends and family with just a few simple steps.
- Export Ribbon: In the Customize Ribbon dialog box, click on Import/Export => Export all customizations.
- Import Ribbon: To import Ribbon, click on Import/Export => Import customizations file.
Above are the complete steps to set up Ribbon in Excel 2016. Hopefully, through this article, you can understand more about Ribbon and how to configure them for convenient use of your Excel 2016. If you have any questions, feel free to comment below, and Mytour's technical team will assist you.
When using Excel, you need to know how to print Excel because printing Excel is not as simple as printing Word documents. Without techniques, data may overflow when printing Excel documents.
