3. In the Source section, scan the column of product code in the List of goods like TipsMake as shown in this picture. Or you can name the data area first by using the Define Name function. Then click OK.
3. In the Source section, scan the column of product code in the List of goods like TipsMake as shown in this picture. Or you can name the data area first by using the Define Name function. Then click OK.
And here is the result, as you can see, there is now a drop down arrow for you to choose.
- Note: In case you can not perform the data validation function, it could be due to a number of reasons as follows:
+ Drop-down lists cannot be created from a table but linked to Office SharePoint tools. If you have a link to this tool, remember to unlink and delete the format, and you do not use it.
+ Because your spreadsheet is in protected mode, for example, the spreadsheet that has been applied the 'password protection for excel' function is not editable or manipulative. The solution is to remove that protection mode and continue to perform the above steps.
- After creating the drop-down list, make sure it works the way you want. Also make sure that the width of the cells in the data validation drop-down box is wide enough to display all the information. If you want to prevent others from impacting on this data. Find a way to hide excel data.
Good luck!