Show warning – If this option is selected, the user can enter incorrect data and only a warning message will be shown. On invalid data: This field will decide what will happen if the user tries to enter incorrect data instead of selecting from the list. Otherwise, the drop-down list will not be visible. Show drop-down list in cell: Make sure that this checkbox is selected. A2:A8) in the box located next to List from a range. If you are not comfortable selecting cells with your mouse, you can manually enter the cell addresses (eg. Once you are done with the selection click OK to confirm. While you start selecting cells with your mouse, you will see a small pop-up menu. Then, you have to select the cells that contain data for creating a drop-down list. Since we want to create a drop-down list from existing data, we need to select the option List from a range. In this example, we have selected a single-cell C1.Ĭriteria: If you click this drop-down box, you will see multiple options for data validation. Let’s see that one by one.Ĭell range: This indicates a single cell or range of cells where you want to insert the drop-down list. In the Data validation window, you will see a lot of configuration options.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |