Select the cells you want to contain in the drop-down list.
Go to ribbon and click “Data,” then “Data Validation.”
In the dialog box, select “Allow to List.”
Click on Source and type the numbers or text that you want in your drop-down lists.
Click OK to continue.
Note that commas should separate the numbers and texts.
Viewing 1 post (of 1 total)
You must be logged in to reply to this topic. Login here