Forum Discussion
Mac Excel 16.9 data validation drop down list
Hi, I am a new user, i have inherited a worksheet with some drop down menus, i would like to add to the list items in the drop down, e.g Country of origin - Thailand to the list, when I right click I get the following pop up data, have also been to the data validation list but it doesn't show any values, have tried to unhide column/worksheets to see any hidden lists but no joy, some assistance would be much appreciated, thank you..
For what it's worth, your image is NOT showing a data validation drop down list; it's the list that appears when you try to Sort based on the column heading. Given the inconsistencies in that list that shows, the spaces, I would think it would be very beneficial to actually have a good Data Validation list.
That is aside from wanting to add Thailand to the list of valid entries, but it's another issue altogether.
An image, sadly, is not anywhere near as effective as the actual worksheet when soliciting help, so may I ask you to post a copy of the actual workbook. Or a reasonable facsimile--after taking out the names of any real people or other confidential info. Then I or somebody else can help with more specific recommendations.
5 Replies
For what it's worth, your image is NOT showing a data validation drop down list; it's the list that appears when you try to Sort based on the column heading. Given the inconsistencies in that list that shows, the spaces, I would think it would be very beneficial to actually have a good Data Validation list.
That is aside from wanting to add Thailand to the list of valid entries, but it's another issue altogether.
An image, sadly, is not anywhere near as effective as the actual worksheet when soliciting help, so may I ask you to post a copy of the actual workbook. Or a reasonable facsimile--after taking out the names of any real people or other confidential info. Then I or somebody else can help with more specific recommendations.
You actually did not have a data validation table for the column on Country of Origin. Nor was it set up as a table.
So I've done both...Sheet 2 now contains a list that is referenced in the Data Validation for column F. And I've turned the array of information on the "Nitrile" sheet into a table, so that as new rows get added, the data validation for column F continues.
If you have the most recent version of Excel, then we could make the Data Validation table one that grows dynamically as new countries get added. You'd need to be able to make the functions UNIQUE and FILTER work...so a way to test whether you have that is simply to start typing in an empty cell, =UNIQUE(..... and see if it lets you complete it.
If it does work, come back and I'll create that data validation list so it expands as you add new legitimate entries.
