Excel selects the ribbon’s Home tab when you open it. Learn how to minimize and customize the ribbon.

Tabs

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

Home Tab

Note: the File tab in Excel 2010 replaces the Office Button in Excel 2007.

Minimize the Ribbon

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

Minimize the Ribbon in Excel

Result.

Hidden Ribbon

Customize the Ribbon

Excel 2010 makes it possible to 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.

Customize the Ribbon

2. Click New Tab.

Click New Tab

3. Add the commands you like.

Add Commands

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.

Result.

Custom Tab

Quick Access Toolbar

If you use an Excel command frequently, you can add it to the Quick Access Toolbar. You can even add commands to the Quick Access Toolbar that are not in the ribbon. By default, the Quick Access Toolbar contains the Save, Undo and Redo button.

To add a command to the Quick Access Toolbar, execute the following steps.

1. Click the down arrow.

2. Click More Commands.

Customize Quick Access Toolbar

3. Under Choose commands from, select Commands Not in the Ribbon.

4. Select Form and click Add.

Add Command

Note: by default, Excel customizes the Quick Access Toolbar for all documents. Under Customize Quick Access Toolbar, select the current saved workbook to only customize the Quick Access Toolbar for this workbook.

5. Click OK.

Click Form

Note: to remove a command from the Quick Access Toolbar, right click the command and click ‘Remove from Quick Access Toolbar’.

Developer Tab

Turn on the Developer tab in Excel if you want to create a macro, export and import XML files or insert controls. To turn on the Developter tab, execute the following steps.

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

Customize the Ribbon in Excel

2. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary).

3. Check the Developer check box.

Turn on the Developer Tab

4. Click OK.

5. You can find the Developer tab next to the View tab.

Developer Tab

Leave a comment

Your email address will not be published. Required fields are marked *