Create a Drop Down List from a Range of Cells in Excel 2003

To make data entry easier, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere on the worksheet. It really does sound harder than it is!

Steps

  1. Create a list of valid entries for the drop-down list, type the entries in a single column or row without blank cells.
  2. Select the cell where you want the drop-down list.
  3. On the Data menu, click Validation, and then click the Settings tab.
  4. In the Allow box, click List.
  5. Specify the location of the list of valid entries, enter a reference to your list in the Source box.
  6. your drop down list will be created.



Tips

  • Note: You may want to sort the data in the order that you want it to appear in the drop-down list.
  • Select the In-cell drop-down check box and select or clear the Ignore blank check box.
  • When specifying the location of the list of valid entries, make sure that the reference or name is preceded with an equal sign (=). For example, enter =ValidDepts.

Warnings

  • The maximum number of entries that you can have in a drop-down list is 32,767

Related Articles

Retrieved from "https://kipkis.com/index.php?title=Create_a_Drop_Down_List_from_a_Range_of_Cells_in_Excel_2003&oldid=352547"