Data Validation List

J

John

I have several lists that I would like to put into drop down boxes. I tried
going to data>validation and then chose list (and select my list) and no drop
down box shows up. This is strange since if I go to a new sheet and do the
same thing I can create a list. Any ideas why I can get it to work with my
existing sheet?

Thanks!
 
B

Bob Phillips

A couple of thoughts

Make sure that you have the 'In-cell dropdown box checked in the
Data>Validation>Settings tab.

In Tools>Options, View tab, under 'Objects' make sure the 'Hide All' box is
not checked.


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

John

I just copied the data in sections to a new sheet... it works then. Strange
since the options you gave were not applicable.
 
Top