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.