![]() ![]() You can always ask an expert in the Excel Tech Community or get support in the Answers community. A drop-down list is a graphical control element, similar to a list box, that allows the user to choose one value from a list. The list is in B3:B6 and the data entry cell is. If you want to delete your drop-down list, see Remove a drop-down list. To create a data validation drop-down list in Excel, you need two things: A list of values and a blank cell to use as the data entry cell. For example, check to see if the cell is wide enough to show your updated entries. If the Source box contains a named range, like Departments, then you need to change the range itself using a desktop version of Excel.Īfter you update a drop-down list, make sure it works the way you want. Then click and drag to select the new range containing the entries. If the list of entries ends up being longer or shorter than the original range, go back to the Settings tab and delete what's in the Source box. In this example, you'd add or remove entries in cells A2 through A5. Hit the Enter or Return key after each so that every item appears on a separate line. Then, enter your list items in the List Entries box. Make sure that New List is selected in the Custom Lists box. To set up the data validation drop-down lists, just select all of the cells in the Num column and go to Data > Data Validation, select List from. Click any cell that has the data validation. In the Formulas and Lists section, click Custom Lists. If the Source box contains a reference to a range of cells (for example, =$A$2:$A$5), click Cancel, and then add or remove entries from those cells. The Best Way to Create Drop-Down Lists in Excel That Are Easy to Maintain, Re-use and Put YOU in Full Control 1. For example: Fruits,Vegetables,Meat,Deli. When you're done, each entry should be separated by a comma, with no spaces. In the Data Validation dialog box, do the following: Under Allow, select List. On the Data tab, in the Data Tools group, click Data Validation. If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need. To make your primary drop-down list, configure an Excel Data Validation rule in this way: Select a cell in which you want the dropdown to appear (D3 in our case). Excel validates that the entry in the cell matches an item from your pre-defined list, or you can simply click on the down arrow to select from. On the Settings tab, click in the Source box. Creating Excel drop down lists, or Data Validation Lists as theyre formally known, enables you to control the value entered into a specific cell by limiting the choices to those on a pre-defined list. Select the cells that have the drop-down list. In Excel for the web, you can only edit a drop-down list where the source data has been entered manually. ![]()
0 Comments
Leave a Reply. |