Allows us to enter data into an Excel spreadsheet from a preset list of entries.
Benefits:
Make data entry easier
Limit the number of acceptable choices.
How to create drop down list:
a) Data in same worksheet
i) Enter data we want in the list.
ii) Click on a cell (the location where drop down list will be created)
iii) Click on “Data” Tab -> Data Validation option.
iv) Click on “Setting” Tab in dialog box.
v) Choose “List” from Allow menu.
vi) Click on the button at Source line.
vii) Drag list of data needed in spreadsheet.
viii) Click OK in dialog box.
ix) A down arrow will appear beside cell. Done.
b) Data in Different worksheet but same workbook
c) Data in Different Worksheet and Different workbook
a) Data in Different worksheet but same workbook
i) Enter data we want in the list.
ii) To define a name for the list, select all cells with data that we want to name.
iii) Click on “Name box” at the left end of formula bar.
iv) Insert name for the cells, for example: Fruit_List.
v) Press Enter.
vi) Follow steps for a(ii) to a(v) above.
vii) Enter “=Fruit_List” in Source line.
viii)
----------
Useful Link:
Same Sheet
http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm
Different Sheets same Workbook & Different Workbook
http://office.microsoft.com/en-us/excel-help/create-a-drop-down-list-from-a-range-of-cells-HP005202215.aspx
