Method One: Of course, the simplest is to open the excel2007 directly, into the operating interface, and then select the text or number in the input cell, and then click the "Data"-"filter" option, and now change the cell to add a drop-down list of operations, as shown in the figure:
Method Two: Open excel2007, go to the page, first select a cell, on the menu to choose "Data"-"Data validation" pop-up data validation of the window bar, and then on the settings menu to make as shown in the picture, we enter data in the "source", we must use the English comma separated, Can not use the Chinese comma Oh.
Method Three: Apply to excel2003 operation, both of these methods can be operated in excel2003
First, on the Excel2003 interface, right-click the menu bar, select Form on the pop-up menu bar to select the combo box: Control in the Form window that pops up. As shown in the figure:
Place the arrow mark on a cell, when the Guan into a fine black cross, in the form of a combo box. Then in the right-key combo box, select Format Control in the pop-up menu, as shown in the figure:
Finally, in the Format Control dialog box, select the Control tab, to set the data source range to the selected cell data, set the cell link to the cell for the parameter or data, and finally click OK, of course this method I do not recommend, is in a bit of trouble. As shown in the figure: