Excel Tips 2010 – Where is the Excel 2010 Data Entry Form?

1 Flares Filament.io 1 Flares ×

The popular data entry form from Excel 2003 was removed from the Ribbon in Excel 2010. I am often asked where this feature went. So what is this feature and where can it be found? Find out in this Excel tips 2010 guide.

What is the Data Entry Form?

The Excel 2010 data entry form makes it easy to;

  • Add new records to a table
  • Edit and delete records from a table
  • Search for records in the table

The data entry form is very user friendly and is a must for anyone who performs alot of data entry, especially in a large table.

The data entry form in Excel 2010

Where is the Data Entry Form in Excel 2010?

The data entry form needs to be added to the Quick Access Toolbar in order to use it. The form button will then always be just one click away.

  1. Click the Customise Quick Access Toolbar button and select More Commands
  2. Click the Choose commands from: list arrow and select Commands Not in the Ribbon
  3. Scroll down and select the Form control

Adding the Form button to the Toolbar

  1. Click the Add button and then Ok

To use the form, just click in any table cell and click the Form button. Excel will automatically detect the column headings.

Use the buttons to the right to add new records, skip through the tables records and enter criteria to find a specific record.

Browse the blog for more Excel tips 2010.

 Using the Form Control in Excel 2010

Leave a Reply

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