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 customize ribbon tab show hide developer tab rename reset

Excel Options >> Customize the Ribbon dialog will open.

excel customize ribbon tab show hide developer tab rename reset

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

excel customize ribbon tab show hide developer tab rename reset

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

excel customize ribbon tab show hide developer tab rename reset

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.

excel customize ribbon tab show hide developer tab rename reset

Or right click then click Move Up or Move On on popup menu

excel customize ribbon tab show hide developer tab rename reset

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.

excel customize ribbon tab show hide developer tab rename reset

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

excel customize ribbon tab show hide developer tab rename reset

Reset all tabs to default settings (include Quick access toolbars)

Click Reset button then click Reset all customization.

excel customize ribbon tab show hide developer tab rename reset