Multiple choices for a cell

[fkheng]

I am creating a worksheet which deals with employee or job candidates
qualifications. Each cell will hold the various details pertaining to a
person's qualifications. Different people have different degrees. This
will be all stored in a single cell and separated by a comma.

Is it possible to create some sort of custom or drop down box which
contains controls or check boxes so as to create a standardised list of
qualifications the data entry clerk can choose from?

For example, i would like a cell to have a drop down box, which is a
field that displays the qualifications a particular graduate holds, for
example, a graduate might have BSc in IT and a BSc in Maths
whereas another might have BSc in Maths and BEng in Civil Engineering,
so there are a variety of combinations...is this possible? or how
should this be achieved?

 

[Murthy]

Select the cell which needs to have the drop-down list, go to Data >
Validation. Under 'Allow', select LIST, and type the values (eg. BSc IT, BSc
Engg etc.), separated by comma in the Source Text Box.

Regards,
Murthy

 

[Debra Dalgleish]

A dropdown list doesn't sound practical for this situation, since you
could have almost as many variations as employees. Perhaps you could use
multiple columns, such as Degree1 (with a dropdown list of BA, BSc, MA,
etc.), Major1 (in which the major could be typed), Degree2, Major2.