Data Validation Dropdown

[jliu2000]

Hi, All,
thanks all the replies.

the cell has data validation setup correctly, with In-Cell Dropdow
checked.
we used to see the dropdown on the cell, then on day, dropdow
disappeared.
if we add new list to the validation for any cell on the sheet, w
don't see the dropdown.

note this happen only to this particular sheet in the workbook. othe
sheets are ok.

excel 2002

 

[JulieD]

have you tried restarting the computer?

Cheers
JulieD

 

[Debra Dalgleish]

Are objects visible?

To make them visible, choose Tools>Options

 

[Gord Dibben]

Maybe you have Tools>Options>View "Objects" "Hide All" checked?

Gord Dibben Excel MVP