Excel Dropdown Listing Length Problem?
We are using excel for data entry in this we are using dropdown for selection.
in this dropdown we are trying to add 20 selections but dropdown allow us to add only 18. so we are missing data.
anyone has solution for this. so we can increase number of selection in dropdown.
Thanks
More Questions From This User See All
Answers & Comments
Verified answer
I infer that you are using a Data Validated cell for your drop down. If so, you should be able to enter 20 choices in the List option without a problem.
If you are using 'List' and using a cell range in the Source textbox, check your range formula. You might have a typo in the formula.
In a data validated cell 'List',you can also directly enter the selections in the Source text box, for example:
1,2,3,4,5,6,7,8,9,10,11,12, 13,14,15,16,17,18,19,20