![]() ![]() The second way to fill your list with options is to choose them from a range of values. Note: On some language versions of Excel you will need to use a semicolon ( ) instead of a comma. The options in your drop-down list will appear in the exact same order that you have typed them. It doesn’t matter whether a space follows your comma or not.Ī longer list of options might look like this: “Red, Blue, Green, Purple, Orange, Yellow, Brown”. For example, if there are only two options to choose from, such as Yes and No, you would simply type “Yes, No” (do not include the quotation marks) in the Source box. The first way is by typing all of the options that you want in your drop-down list, separated by commas, into the Source field. Drop-down List from Comma Separated Values You’ll want to select List in the drop-down menu under Allow.Īt this point there are a few ways that you can tell Excel what items you want to include in your drop-down list. The keyboard shortcut to open the Data Validation window is Alt, A, V, V. ![]() ![]() To create a drop-down list, start by going to the Data tab on the Ribbon and click the Data Validation button. How to Create a Drop-down (Data Validation) List We can also use drop-down lists to create interactive reports and financial models, where results change when the user changes a cell’s value. This can be helpful when multiple users are entering data on the same sheet and you want the options to be limited to a list of items or values that you’ve already approved. They help to make sure that only valid data makes it into the cells that you’ve applied it to. That’s why they are also called data validation lists. It also helps restrict entries so that only values you’ve approved make it onto the sheet. Data-Validation-Lists-Examples.xlsx Download What Are Data Validation Lists?Ĭreating a drop-down list is a great way to ensure that entries are uniform and free from spelling errors. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |