Drop Down List in Every Cell of a column

[ssb]

Hello,

Say, I have column called "Employee Designation" in a excel 2k
spreadsheet. This spreadsheet kind of plays the role of a simple form.

Everytime a user updates the spread sheet for a new row, I want the
cell under "Employee Designation" column to appear as a drop down
list.

In fact, whevever a user has to choose between a fixed set of values
for a given cell, I would want a drop down list to appear.

How do I go about it..??

thanks for the help.

 

[Frank Kabel]

Hi
as a starting point:
http://www.contextures.com/xlDataVal01.html

 

[Manuel]

Try using Data Validation. Go to Data / Validation... In
the Allow box select List, then in the Source field
indentify the range on your worksheet which contains the
lookup values. Only limitation is that your lookup values
have to stored on the same sheet.

Manuel

 

[Debra Dalgleish]

You can use a list from a different sheet if the list is a named range.
There are instructions here:

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

 

[ssb]

Hi
as a starting point:
http://www.contextures.com/xlDataVal01.html

This site appears to be nice.......Thanks.....