Creating pull downs

[sjs]

I've seen in other people's excel worksheets, where they
have a pull down button in the cell and when you click on
it it gives you a pick list where you can choose the
value you want and insert the value into that cell. The
list exists elsewhere on the worksheet or another within
the same work book (I think). This is what I want to
do...how do I do this?

 

[J.E. McGimpsey]

Take a look at Validation in XL Help. You'll want to use a List
(either directly entered or as a reference to a range) as your
Source.