This article show how to customize ribbon in Microsoft Excel. Show or hide tab, show Developer tab, Order tab, rename tab and reset tab to default
Customize the Ribbon dialog
Right click on ribbon tab then click Customize the Ribbon…
Excel Options >> Customize the Ribbon dialog will open.
Show or Hide the ribbon tab
Check the box of tab do you want to show or Clear the box for hide the ribbon tab then click OK button
Show Developer tab
Developer tab don’t show when you first install Excel. But you can add it back. By simple steps.
On Excel Options >> Customize the Ribbon dialog. Check the box of Developer then click OK button
Order Ribbon tabs
Excel allow you order ribbon tab by click on ribbon name then click Move up or Move down button on right side.
Or right click then click Move Up or Move On on popup menu
Rename ribbon tab
You can rename default ribbon tab by click the tab that you want to rename then click Rename button and then type new name, click OK button.
Reset ribbon tab
You can reset your ribbon tab to default setting. You can reset all tabs (include Quick access toolbars) or reset selected tab only. You can reset ribbon tab follow these step
Reset selected tab only
Right click on tab then click Reset Tab
Reset all tabs to default settings (include Quick access toolbars)
Click Reset button then click Reset all customization.