Datasheet

Part I: Creating Spreadsheets

Exercise 1-4: Adding Commands to a Custom Tab

In Exercise 1-4, you get practice adding commands to the custom tab you added to the

Ribbon in Exercise 1-3. Before you start this exercise, make sure that the Excel Options

dialog box is still open with a Misc (Custom) tab appearing in the Main Tabs list box

between View and Developer.

1. Click the New Group (Custom) listing under Misc (Custom) in the Main Tabs list

box to select it and then click the Rename button.

Excel opens the Rename dialog box where you can replace the generic New Group

name with your own descriptive name.

2. Replace New Group by typing Data Form in Display Name text box and then

selecting OK.

Data Form (Custom) now appears as the sole group on the Misc custom tab in the

Main Tabs list box. Now, you’re ready to add the Form command button to the

Data Form group that you can use later on when completing some of the exercises

in Chapter 17.

3. Click the drop-down button to the right of Popular Commands in the Choose

Commands From drop-down list box at the top of the left side of the Customize the

Ribbon panel and then click Commands Not in the Ribbon.

Excel now displays an alphabetical list of commands that are not currently on the

Ribbon in the list box on the left.

4. Click the Form button in this Commands Not in the Ribbon list box and then click

the Add command button.

Excel adds the Form button under the Data Form (Custom) group in the Main Tabs

list box.

5. Click the OK button to close the Excel Options dialog box.

The custom Misc tab you just created now appears at the end of the Excel 2010

Ribbon.

6. Click the Misc tab or press Alt+Y to select this tab.

The Misc tab is selected, displaying its sole Form button in the single Data Form

group.

7. Click the Home tab to select it.

Selecting Commands on the

Quick Access Toolbar

When you first start working with Excel 2010, the Quick Access toolbar contains only

the following three simple command buttons:

✓ Save to save changes to your current workbook file

✓ Undo to reverse the effect of the last change you made to a worksheet

✓ Redo to restore the last change you reversed with the Undo button

05_489604-ch01.indd 1605_489604-ch01.indd 16 7/29/10 11:25 PM7/29/10 11:25 PM