How To Create Drop List di Excel

How to create drop list in excel

A. Methode 1

1. Click cell target
2. Click Data > Data Validation.
3. In Validation Criteria, choose list and input the "option" on Source , current we use Yes/No

4. Left Ignore Blank and In-cell dropdown cheked,
5. On  Error Alert tab, On Check list Show Error Alert After Invalid Data is Entered.
    - if Cheked, only allowed Yes or No
    - if Not Checked, it wil be alowed except Yes or No
6. Click OK

B. Methode 2
1. Make a list of option in some cells, example: Apple, Mangga, Pisang, Duren
2. Select the cells that contains the option.
3. Klik Data >  Data Validation
4. Validation Criteria, choose list and select source data

5. click OK