Microsoft Office Tutorials and References
In Depth Information
with a form
Creating a list is a two-step process: First, you create
the structure, which consists of a series of text
labels, one per cell, each describing the content of a
column. Then you enter the data. Excel enables you
to generate a form to simplify data entry.
A form simplifies and speeds up data entry by
providing a blank field for each column in your table.
You type the data and press the Tab key to move
from field to field. After you complete one set of
fields, you enter them into a row in your list and
start entering a new set of fields. You can move
backward and forward through your list to view or
modify your data. The list form also doubles as a
search box you can use to retrieve values.
You must add the Form button to the Quick Access
toolbar before you can use forms. See Task #95
to learn how to add a button to the Quick Access
Type your column heads.
Click and drag to select your
Click the Form button.
A warning appears.
Read the warning and then click