Excel selects the ribbon's Home tab when you open it. Learn how to collapse and customize the ribbon. Microsoft Excel ribbon is the row of tabs and icons at the top of the Excel window that allows you to quickly find, understand and use commands for completing a certain task. It looks like a kind of complex toolbar, which it actually is. The ribbon first appeared in Excel 2007 replacing the traditional toolbars and pull-down menus found in previous versions. In Excel 2010, Microsoft added the ability to personalize the ribbon. The ribbon in Excel is made up of four basic components: tabs, groups, dialog launchers, and command buttons.



The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review, View and Help. The Home tab contains the most frequently used commands in Excel.

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).

Customize the Ribbon


You can easily create your own tab and add commands to it. If you are new to Excel, you can skip this paragraph.

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


Screenshot (39).png
Screenshot (40).png

2. Click New Tab.

3. Add the commands you like.

Screenshot (41).png

4. Rename the tab and group.

Screenshot (42).png

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.

5. Click OK.

Screenshot (43).png