Hi Everybody,

Would you tell me if there's any functions in Excel 2000 to make a drop list
in a cell, for preventing users from any typing errors.

Let's say they have to key in data in colume 'DEPARTMENT', so should confine
them to 'Marketing','Porduction','Accounting','Administrat ion', etc. Thought
that dropdown list to select items would be tbe better choice.

Thanks & regards!