Adding the Form button to the Quick Access toolbar in Excel 2007

Instead of entering the records of a data list directly in the table, you can use Excel's data form to make the entries. The only problem with using the data form is that the command to display the form in a worksheet with a data list is not part of the Ribbon commands.

You can access the data form only by adding its command button to the Quick Access toolbar. To do this, you must follow these steps:

1. Click Office Button > Excel Options > Customize or press Alt+FIC.
The Form command button you want to add is only available when you click the Commands Not in the Ribbon option on the Choose Commands From drop-down list.

2. Click the Commands Not in the Ribbon option near the bottom of the Choose Commands From drop-down list.

3. Click Form in the Choose Commands From list box and then click the Add button.
Excel adds the Form button to the very end of the Quick Access toolbar. If you so desire, you can click the Move Up and Move Down buttons to reposition the Form button on this toolbar.

4. Click OK to close the Excel Options dialog box and return to the worksheet with the data list.

Tags: data list,worksheet,ribbon

Related Articles