Creating pull downs

S

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?
 
C

Chip Pearson

This is called Data Validation, accessible from the Data menu. First, put
the list of values you want to appear in the drop down list in some range of
cells. Then select the cells that you want to have drop down lists. Go to
the Data menu and choose Validation. There, choose List from the Allow list
box, and enter the range containing the values.
 
Top