![\"Excel](\"https:\/\/support.content.office.net\/en-us\/media\/4018439e-9c1d-4bbd-8618-4301b21d051f.png\")
Notes:<\/strong> - Why should you put your data in a table? When your data is in a table, then as you add or remove items from the list<\/a>, any drop-downs you based on that table will automatically update. You don’t need to do anything else.<\/li>
- Now is a good time to Sort data in a range or table<\/a> in your drop-down list.<\/li><\/ul><\/li>
- Select the cell in the worksheet where you want the drop-down list.<\/li>
- Go to the Data<\/strong> tab on the Ribbon, then Data Validation<\/strong>.Note:<\/strong> If you can\u2019t click Data Validation<\/strong>, the worksheet might be protected or shared. Unlock specific areas of a protected workbook<\/a> or stop sharing the worksheet, and then try step 3 again.<\/li>
- On the Settings<\/strong> tab, in the Allow<\/strong> box, click List<\/strong>.<\/li>
- Click in the Source<\/strong> box, then select your list range. We put ours on a sheet called Cities, in range A2:A9. Note that we left out the header row, because we don’t want that to be a selection option:
![\"Data](\"https:\/\/support.content.office.net\/en-us\/media\/c04c2085-05f2-4d36-b68c-edb9cea91be4.png\")
<\/li>- If it\u2019s OK for people to leave the cell empty, check the Ignore blank<\/strong> box.<\/li>
- Check the In-cell dropdown<\/strong> box.<\/li>
- Click the Input Message<\/strong> tab.
- If you want a message to pop up when the cell is clicked, check the Show input message when cell is selected<\/strong> box, and type a title and message in the boxes (up to 225 characters). If you don\u2019t want a message to show up, clear the check box.
![\"Data](\"https:\/\/support.content.office.net\/en-us\/media\/35dd530d-334d-405f-a9e7-3b0ac0ccee4a.png\")
<\/li><\/ul><\/li>- Click the Error Alert<\/strong> tab.
- If you want a message to pop up when someone enters something that’s not in your list, check the Show error alert after invalid data is entered<\/strong> box, pick an option from the Style<\/strong> box, and type a title and message. If you don\u2019t want a message to show up, clear the check box.
![\"Data](\"https:\/\/support.content.office.net\/en-us\/media\/d650b814-cda5-4470-9478-6d331b48a4ee.png\")
<\/li><\/ul><\/li>- Not sure which option to pick in the Style<\/strong> box?
- To show a message that doesn\u2019t stop people from entering data that isn\u2019t in the drop-down list, click Information<\/strong> or Warning. Information will show a message with this icon
![\"Message](\"https:\/\/support.content.office.net\/en-us\/media\/7d330039-f98d-42a5-b75b-779ddbac24db.jpg\")
and Warning will show a message with this icon ![\"Message](\"https:\/\/support.content.office.net\/en-us\/media\/5f150f3c-1d3d-4210-b439-7bb2701d0764.jpg\")
.<\/li>- To stop people from entering data that isn\u2019t in the drop-down list, click Stop<\/strong>.Note:<\/strong> If you don’t add a title or text, the title defaults to “Microsoft Excel” and the message to: “The value you entered is not valid. A user has restricted values that can be entered into this cell.”<\/li><\/ul><\/li><\/ol>\n\n\n\n
Ref: https:\/\/support.microsoft.com\/en-us\/office\/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b<\/p>\n","protected":false},"excerpt":{"rendered":"
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, you\u2019ll have your list items in an Excel table. If you don\u2019t, Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[689,688],"class_list":["post-3240","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-drop-down-list-2","tag-drop-down-list"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t
- To stop people from entering data that isn\u2019t in the drop-down list, click Stop<\/strong>.Note:<\/strong> If you don’t add a title or text, the title defaults to “Microsoft Excel” and the message to: “The value you entered is not valid. A user has restricted values that can be entered into this cell.”<\/li><\/ul><\/li><\/ol>\n\n\n\n
- Not sure which option to pick in the Style<\/strong> box?
- Click the Error Alert<\/strong> tab.
- Now is a good time to Sort data in a range or table<\/a> in your drop-down list.<\/li><\/ul><\/li>