Ribbon

 

Excel selects the ribbon's Home tab when you open it. Learn how to use the ribbon.

Tabs

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.

Tabs

Groups

Each tab contains groups of related commands. For example, the Page Layout tab contains the Themes group, the Page Setup group, etc.

Groups

Use the Ribbon

Let's use the ribbon to create a table. Tables allow you to analyze your data in Excel quickly and easily.

1. Open data-set.xlsx.

2. Click any single cell inside the data set.

3. On the Insert tab, in the Tables group, click Table.

Use the Ribbon

The Create Table dialog box appears.

4. Excel automatically selects the data for you. Check 'My table has headers' and click on OK.

Create Table

Result: Excel creates a nicely formatted table for you.

Excel Table

Note: use the drop-down arrows to quickly sort and filter. Visit our chapter about tables to learn more about this topic.

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

Result:

Hidden Ribbon