Adding drop down list in Excel 在Excel中增加下拉框

Categories: Development Notes; Tagged with: ; @ September 5th, 2012 17:33

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