making a drop down box

M

michael.j.bates

i made a list for a drop down box,I have 40 items counting the title of the
box.I used the data validation button & the box works fine.all 40 items are
in the box but the list is still visible.How do I make it so the list is not
visible but the items remain in the box?
 
G

Gord Dibben

Are you sure you used Data Validation>Allow>List>In-cell Dropdown?

The arrow and list are invisible until you select the cell.

Maybe you used a ComboBox from the Forms Toolbar or Control Toolbox.

Both those remain visible.


Gord Dibben MS Excel MVP
 

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

Excel 2003 Drop Down Box 2
Drop Down Boxes 1
Nesting drop down lists? (Excel 2007) 9
Drop Down Lists 4
Drop-down list and error message 1
drop down box issues 1
Copying List box values/selection to a database of sorts 2
Creating a Graph from a Drop Down List in Excel 2

Top