1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Add the Data Entry Form to the Quick Access Toolbar

Customize the Quick Access Toolbar in Excel

By

Access the Data Form in Excel

Access the Data Form in Excel

© Ted French

Related tutorial: Excel Data Entry Form.

The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel . It is also where you can add the shortcuts to Excel features that are not available on the ribbon.

One of these features is the data entry form.

The data form is a quick and easy way to add data to an Excel database table.

For some reason, however, Microsoft chose not to add the form to one of the tabs of the ribbon starting with Excel 2007.

Below are steps that will show you how to add the Form icon to the Quick Access Toolbar.

This is a onetime operation. Once added, the Data Form button remains available on the Quick Access Toolbar.

Add the Data Form to the Quick Access Toolbar

For help with these steps, see the image above.

  1. Click on down arrow at the end of the Quick Access Toolbar to open the drop down menu.

  2. Choose More Commands from the list to open the Customize the Quick Access Toolbar dialog box.

  3. Click on down arrow at the end of the Choose commands from line to open the drop down menu.

  4. Choose All Commands from the list to see all the commands available in Excel 2007 in the left hand pane.

  5. Scroll through this alphabetical list to find the Form command.

  6. Click on Add button between the command panes to add the Form command to the Quick Access Toolbar.

  7. Click OK.

  8. The Form button should now be added to the Quick Access Toolbar.

Related Tutorials

©2014 About.com. All rights reserved.