List Dropdowns Disapeared

B

bigb

I have numerous lists on one sheet and all the dropdown boxes have
disapeared. I can add the values by hand, with no errors. I have checked the
validation secion and the lists are still there. Can anyone help me get my
list dropdown boxes back without having to redevelop it.
 
I

intruder9

Validation lists do not usually show a box until you click on the cel
with the data validation, if you want to have a box that shows you ma
want to use conbo boxes ibnstead or color the cell so people know wher
the box selection cell is located
 
W

William Horton

bigb is correct. However, if you click on the cell and still can't see the
drop down box try checking your view settings. From the menu path choose
Tools / Options and then click the View tab. Under the Objects section
ensure that Hide all is NOT selected.
 
P

Patti

Just a thought -- I had this happen on a spreadsheet of mine because I had
frozen the panes. When I selected "Window -- Unfreeze Panes", the drop down
box re-appeared.
 
B

bigb

Willam, Thanks for the reply.

I just found out one more piece of the puzzle. This is only occuring on one
sheet. All the other sheets work properly. Any suggestions?

Thanks. BigB
 
Top