1. preparing the data source: just input your values in file;
2. Edit the validation of the target cell(s): Data/Validation:
3. Click ‘OK’, now, you can see the list when you click the cell. if needed, you can use the auto fill tool to set validation for other cells.
// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.