Excel drop down list arrow has disappeared.

G

Guest

I have created a drop down list in an Excel file. I set it up for a cell to
refer to to the list via Data - Validation, but when the cell is chosen, the
drop down arrow does not appear. It has worked for months but it has now
stopped. I tried to delete it and re-create it, but it still does not show
the drop down arrow and list. What do I do?
 
S

starguy

go to menu Data > Validation and check the option in-cell dropdown if i
is unchecked.
 
S

starguy

go to menu Data > Validation and check the option in-cell dropdown if i
is unchecked.
 

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

DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Drop down fill box does not appear when cell clicked. 1
Keyboard Shortcut for Drop Down List 3
Excel Drop Down Lists 9
Drop down list help 15
Drop down list 1
Can I increase the view of a drop down list beyond 8 in Excel? 2
In-Cell Drop Down List not properly working 7

Top