Microsoft Office Tutorials and References
In Depth Information
Using the Excel Built-In Data Entry Form
Using the Excel Built-In Data Entry Form
When entering data into an Excel list, some people prefer to use Excel’s data entry form — a
dialog box that adjusts to your data. Before you can use this form, you have to set up the column
headers in your worksheet. Alternatively, you can designate the data range as a table, by
choosing Insert
Tables
Table.
The Data Form command doesn’t appear on the Ribbon, so you need to do a bit of prep work.
Here’s how to add the command to the Quick Access toolbar:
1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar from
the shortcut menu.
Excel displays the Quick Access Toolbar tab of the Excel Options dialog box.
2. In the drop-down list on the left, choose Commands Not in the Ribbon.
3. In the list box on the left, choose Form and then click the Add button.
4. Click OK to close the Excel Options dialog box.
After you perform these steps, your Quick Access toolbar includes a new icon that, when clicked,
displays the data entry form.
Activate any cell within your list and choose the Form command from your Quick Access toolbar.
You see a dialog box like the one shown in Figure 41-1. (The fields shown in the dialog box vary,
depending on your column headers.)
Figure 41-1: The Excel data entry form.
If the number of columns in your list exceeds the limit of your display, the dialog box
contains two columns of field names. If your list consists of more than 32 columns,
however, the Form command doesn’t work. You must forgo this method of data entry
and enter the information directly into the cells.
 
Search JabSto ::




Custom Search