Excel drop down list arrow has disappeared.
 

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?

Excel drop down list arrow has disappeared.
 

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

Tony Maly Wrote:
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?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=573066