Microsoft Office Tutorials and References
In Depth Information
Displaying a Data Form
In the list box on the left, select Form.
Click the Add button to add the selected command to your Quick Access toolbar.
Click OK to close the Excel Options dialog box.
After performing these steps, a new icon will appear on your Quick Access toolbar.
Figure 12-12: Some users prefer to use Excel’s built-in data form for data-entry tasks.
To use a data entry form, you must arrange your data so that Excel can recognize it as a table.
Start by entering headings for the columns in the first row of your data entry range. Select any
cell in the table and click the Form button on your Quick Access toolbar. Excel then displays a
dialog box customized to your data. You can use the Tab key to move between the text boxes
and supply information. If a cell contains a formula, the formula result appears as text (not as an
edit box). In other words, you can’t modify formulas from the data entry form.
When you complete the data form, click the New button. Excel enters the data into a row in the
worksheet and clears the dialog box for the next row of data.