Hi
see:
http://www.contextures.com/xlDataVal01.html

-----Original Message-----
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!
.