Create a drop-down list on Microsoft Excel
- On a new worksheet, type the entries that you want to appear in your drop-down list. The entries should be in a single column or row without any blank cells, like this:
- Select all of your entries or the whole column using (CTRL+Shift+Down) and , right-click, and then click Define Name.
- In the Name box, type a name for your entries, for example, HW_Group, and then click OK. Be sure your name doesn’t have any spaces in it. This name won’t show up in your list, but you need to name it so you can link it to your drop-down list.
- Click in the cell in the worksheet where you want the drop-down list.
- Click Data >Data Validation.
- On the Settings tab, in the Allow box, click List.
- In the Source box, type and equal sign (=), immediately followed by the name you gave your list in step 3. For example, =HW_Group.
- Check the In-cell dropdown box.
- If it’s OK for people to leave the cell empty, check the Ignore blank box.
- Click the Input Message tab.
- If you want a message to pop up when the cell is clicked, check the Show input message when cell is selected box, and type a title and message in the boxes (up to 225 characters). If you don’t want a message to show up, clear the check box.
- Click the Error Alert tab.
- Check the Show error alert after invalid data is entered box, pick an option from the Style box, and type a title and message. If you don’t want a message to show up, clear the check box.
- You’ll find your drop-down list as following.