Create category Drop-down list fill item in Excel table

Source: Internet
Author: User

1, in Sheet2, the name of the enterprise by category (such as "Industrial Enterprise", "Commercial enterprise", "individual enterprise", etc.) into different columns, the establishment of a database of enterprise names.

2, select Column A ("Industrial enterprise" name of the column), in the "Name" column, enter the "industrial Enterprise" character, press "enter" key to confirm.

Imitate the above operation, will B, C ... The columns are named "Commercial enterprise", "Individual Enterprise", respectively.

3. Switch to Sheet1, select the column (such as column C) where you want to enter the enterprise category, and execute the data → effectivity command to open the Data Validation dialog box. In the Settings tab, click the Drop-down button to the right of allow, select the sequence option, and in the Source box below, enter "industrial Enterprise", "Commercial enterprise", "Individual enterprise" ... Sequence (separated by commas between the elements), OK exit.

Select the column you want to enter the enterprise name for, such as column D, and then open the Data Validation dialog box, select the series option, and then enter the formula in the Source box: =indirect (C1), OK exit.

4, select the C column any cell (such as C4), click the Right Drop-down button, select the appropriate "Enterprise category" to fill in the cell. Then select the cell in column D (for example, D4) and click the Drop-down button to fill in the cell with the desired enterprise name from the list of enterprise names for the category.

Tip: If you don't need to print the Enterprise category column when you print the report later, you can select the column, right-click, and hide the column by selecting the Hide option.

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: and provide relevant evidence. A staff member will contact you within 5 working days.