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
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
