Try Microsoft Edge A fast and secure browser that's designed for Windows 10 No thanks Get started. You can provide a more efficient worksheet by using drop-down lists in cells where people can make a Yes or No choice, pick a date from a calendar, or pick from another list you insert.

Someone using your worksheet clicks an arrow, and then clicks an entry in the list. 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:.

Now is a good time to Sort your data in the order you want it to appear in your drop-down list. Select all of your entries, right-click, and then click Define Name. In the Name box, type a name for your entries, for example, ValidDepts.

Here are a few reasons why that might happen. Unlink the table or remove the table formatting, and then try step 5 again. The worksheet might be protected or shared. Remove the protection or stop sharing the worksheet, and then try step 5 again. On the Settings tab, in the Allow box, click List. 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 characters. Check the Show error alert after invalid data is entered box, pick an option from the Style box, and type a title and message.

Information will show a message with this icon and Warning will show a message with this icon. If you don't add a title or text, the title defaults to "Microsoft Excel" and the message to: A user has restricted values that can be entered into this cell.

After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if the cell is wide enough to show all your entries. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet. For more information about how to protect a worksheet, see Lock cells to protect them. If you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list.

To delete a drop-down list, see Remove a drop-down list.

excel - How to make a drop-down list for worksheets - Stack Overflow

To see a video about how to work with drop-down lists, see Create and manage drop-down lists. Post a question in the Excel community forum. Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice. Apply Data Validation to cells. Freeze rows and columns.

Add a check box. Overview of formulas in Excel.

How to Create a Drop-Down List in Excel - BetterCloud Monitor

How to avoid broken formulas. Find and correct errors in formulas. Keyboard shortcuts in Excel for Windows. Keyboard shortcuts in Excel for Mac.

Excel functions by category. Search Office help No results.

Create a drop-down list - Office Support

Enter and format data. Excel Excel Excel Excel Excel for Mac More Was this information helpful? How can we improve it? Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents. Learn Windows Office Skype Outlook OneDrive MSN.

How to Make a Drop Down List With Colors in Microsoft Excel | umisifuy.web.fc2.com

Devices Microsoft Surface Xbox PC and laptops Microsoft Lumia Microsoft Band Microsoft HoloLens. Downloads Download Center Windows downloads Windows 10 apps Office apps Microsoft Lumia apps Internet Explorer. Values Diversity and inclusion Accessibility Microsoft in education Microsoft philanthropies Corporate social responsibility Privacy at Microsoft. Company Careers About Microsoft Company news Investors Research Site map.