Excel dropdown list How to do

Source: Internet
Author: User

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:

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.