Customize the Ribbon | Collapse the Ribbon

The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. Excel selects the ribbon's Home tab when you open a workbook.

Customize the Ribbon

You can easily create your own tab and add commands to it.

1. Right click anywhere on the ribbon, and then click Customize the Ribbon.

Customize the Ribbon in Excel

2. Click New Tab.

Click New Tab

3. Add the commands you like.

Add Commands to the Ribbon

4. Rename the tab and group.

Rename Tab and Group

Note: you can also add new groups to existing tabs. To hide a tab, uncheck the corresponding check box. Click Reset, Reset all customizations, to delete all Ribbon and Quick Access Toolbar customizations.

Collapse the Ribbon

You can collapse the ribbon to get extra space on the screen. Right click anywhere on the ribbon, and then click Collapse the Ribbon (or press CTRL + F1).

Collapse the Ribbon

1/3 Completed! Learn much more about the ribbon >
Go to Next Chapter: Workbook   |   Become an Excel Pro: 300 Examples