Look at Data Validation again.
Allow LIST
Enter
yes, no, excellent, good, satisfactory, poor
As your list.

You could also have a named range with your lists in them, but that is a bit
more complex.

"addy" wrote:

Thanks. Looked at data validation but I don't think that's what I want. I
want a drop down list to pick from such as yes, no or excellent, good,
satisfactory, pooor etc.

Thanks

"Barb Reinhardt" wrote:

Are you saying you want to be able to select something from a list in a
specific cell? If so, you want to use Data Validation. If it's something
else, come back and clarify your question.

"addy" wrote:

I don't use excel that much but I want to add a scroll bar to excel with a
list of items to pick. I guess I use a scroll bar. I've manged to add a
scroll bar but can't find how to add my list. Do I have to use VBA or is it
simpler than that - can't find any help on help!!

Many thanks