Data validation dropdown arrow disappeared

G

Guest

I have cells with data validation using a list, but suddenly the dropdown
list doesn't appear when the cell is selected. The validation is still
functional, but no dropdown on a specific worksheet. If I create a similar
validation on another sheet in the same book, it works just fine. What's
going on?
 
G

Gord Dibben

Dan

Have you got "in-cell drop down" un-checked for that particular DV dropdown on
that sheet?


Gord Dibben MS Excel MVP
 
G

Guest

Ensure that in the Excel Options->Advanced the Display options for this
workbook has "For all objects show... All" selected, otherwise dropdown lists
will no longer show up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Error 1
Displaying arrow in a dropdown list within cell 2
Data Validation Dropdown List Not Working 4
Validation dropdown list is not available 1
Data Validation List: Text Size Query 2
2007 data validation not working 1
Data validation 10
Data validation with dropdown list 2

Top