How does Excel set up the two-level linkage pull-down menu?

Source: Internet
Author: User
Tags first row

How does Excel set up the two-level linkage pull-down menu? There are several ways to make a drop-down menu in Excel, I mainly introduce the next use data validation settings Drop-down menu and how to set the two-level linkage drop-down menu. Both of these methods will be illustrated by examples.

Setting up a Pull-down menu with data validation

Example: As shown in the following illustration, you are required to set a Drop-down menu that can be selected in the Salesperson column.

Step 1: Select a salesperson column that needs to set the drop down menu in the range of cells (this step is not less), open the Data Validation window (excel2003 version of the Data menu-effectivity, excel2007 and 2010 Version Data tab-data validation-data validation), in the window "settings" Option Kari "sequence".

Step 2: In the source input box we need to set the Drop-down menu to display the content, there are two ways to set up.

1, direct Input method. In the Source box, enter the string that is connected with "," (English comma): Zhang Yi, Wuhanqing, Liu, will win the text, Li Damin

2, the contents of the reference cell method. If the salesperson is in the cell B4:b8 area, select the area after the "source" type or the last fold button in the Point box. As shown in the following figure.

Once we have set up, we can see the drop down menu in the Salesperson list.

二、二级 Linkage pull-down Menu Settings

Example: As shown in the following picture, in the mobile phone column input or select Apple, Model dropdown will show all the models of all Apple phones, if the cell phone input apple, the Model column Drop-down menu shows all the Apple model. As shown in figure:

Operation Steps:

Step 1: Set the data source area. is to put the phone name and model as the following image format standby, storage location at random.

Step 2: Batch definition name. After selecting the phone name and model area, open the specified name window (excel2003 version, Insert menu-name-Specify, 07 and 10 Formulas tab-defined name groups-created from the selection), select the First row check box on the window. As shown in the following figure.

Step 3: Set data validation. Select the Model column, open the Data Validation window, and enter =indirect (D5) in the source

After the following settings, level two linkage menu settings completed.

Note the name of the different versions, depending on the version you are working on.

Above is how Excel set up two-level linkage drop-down Menu method Introduction, the operation is not very difficult, have the need of friends quickly to learn!

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.