Create a Drop-down List in Excel (Easy Steps)
Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values. Create a Drop-down List To create a drop-down list in Excel, execute the following steps. 1. On the second sheet, type the items you want to appear in the drop-down list. Note: if you dont want users to access the items on Sheet2, you can hide Sheet2. To . . .
more
|