![]() 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 |