Microsoft Office Tutorials and References
In Depth Information
Entering Data in a Table Using a Drop-Down List
Entering Data in a Table Using a Drop-Down List
Entering data in a list can be tedious and repetitive. You can enter data using the PickList
or List AutoFill feature to make the job easier. PickList is activated once you have entered
at least one record in the list; it uses your previous entries to save you the trouble of typing
repetitive information. PickList displays previous entries made in the current field in a list
format. List AutoFill automatically extends the list’s formatting and formulas to adjacent
cells. As data is added to a list, AutoFill looks at the preceding cells to determine what
formatting and formulas should be extended.
Enter Data in a List Using Pick From Drop-Down List
Right-click the cell in which you want to use PickList, and then click Pick
From Drop-Down List .
Click a selection in the list.
Search JabSto ::




Custom Search