Excel Drop Down Box

[chris313]

I'm trying to edit an excel worksheet that has drop down boxes.
However, the drop down boxes are not typical forms. These drop dow
boxes appear to be normal cells (They contain text). When I click o
the box, a little gray box shows up w/ a down arrow to the right of th
cell. However, if you right click on the cell, there aren't an
property options that are displayed.

I was wondering if anybody had any idea what kind of drop down box thi
is. How can I edit or create one

 

[Dave Peterson]

It sounds like it's under Data|Validation.

I'm trying to edit an excel worksheet that has drop down boxes.
However, the drop down boxes are not typical forms. These drop down
boxes appear to be normal cells (They contain text). When I click on
the box, a little gray box shows up w/ a down arrow to the right of the
cell. However, if you right click on the cell, there aren't any
property options that are displayed.

I was wondering if anybody had any idea what kind of drop down box this
is. How can I edit or create one?

 

[Max]

If it's data validation (and it probably is),

visit MVP Debra Dalgleish's nice coverage of Data Validation
(with screen details / pictures) at her:

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