Web the data validation dialog box displays.
How to create drop down list in excel with data from another sheet. In the data validation window that opens, select list under allow, and under source,. Make sure the items are consecutive (no blank rows). Web then select data from the menu, and select data validation in the ribbon.
You can make a worksheet more. You can add or delete items from your drop.