Create Named List:

a. In an empty area of the workbook, type the entries you want to see in the drop-down lists. These should be one-word entries, to match the dependent list names that will be created.
b. Select the cells in the list (but not the heading).
c. Click in the Name box, to the left of the formula bar
d. Type a one-word name for the list, e.g. Produce.
e. Press the Enter key.

To apply the cell validation using the Named list,
a. Select the cells in which you want to apply Excel data validation using the Category List
From the Data menu, choose Validation.

c. From the Allow drop-down list, choose List
d. In the Source box, type an equal sign and the list name, for example: =Produce
e. Click OK.