Hidden Drop Down List

  • Thread starter Thread starter Angela
  • Start date Start date
A

Angela

I can't see the drop down list that I have created. Any ideas why?
 
hi
is it data validation? you can't see it untill you click in the cell.

regards
FSt1
 
The list was created using Validation, however when I click on the cell where
the drop down list should appear, nothing. It doesn't give the drop down
list.
 
Yes it is. All seems to be ok, however I'm just not seeing the drop down box.
 
Did you ever get this resolved? I'm having the same problem in Excel 2007.
The 'In-cell dropdown' option is checked, and 'For objects->show all' is
checked (in Office Button->Excel options->Advanced->Display options for this
workbook). I can see the dropdown lists on one worksheet but not on another,
so it must be something cell or worksheet specific, rather than a setting for
the whole workbook. (?)

Jey
 
Hi,
Thanks for the link. It wasn't any of those, but on a whim I just copied
everything to a new worksheet, and now it all works fine! I tried copying
back to the original worksheet, and still no list. Very odd, but I'm not
going to loose any sleep trying to figure it out... its all good now.
Jey
 
You must log in or register to reply here.

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

Filtered drop down list 2
alt down arrow shortcut not working 0
Drop Down Problems 2
Using one source list for two depends drop-down list 2
Drop-Down List 3
How do I change a drop down list? 1
Drop down list 1
Drop Down List Contains the List Header Row 1

Back
Top