Is there any option that would disable this function? I've been creating drop down lists for a long time, but in this particular worksheet. I tested in other worksheets in the same workbook and it works fine. Please help.
Is there any option that would disable this function? I've been creating drop down lists for a long time, but in this particular worksheet. I tested in other worksheets in the same workbook and it works fine. Please help.
Check the data validation window and make sure the "in-cell drop down" checkbox is checked.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
In-Cell drop down was checked.
This site shows some options:
www.contextures.com/xldataval08.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks