A drop down selection appears in an excel cell

sheet2 b2 input =vlookup(a2,sheet1!a2:b16,2,0).

There is no need to do data validity.

Do it in a data validity way:

1。Create base data in the sheet1 table: (manually entered).

A1 provinces, B1 Zhejiang, C1 Jiangsu, D1 Hunan;

A2 City, B2 Hangzhou, B3 Taizhou, C2 Nanjing, D2 Changsha, D3 Zhuzhou, D4 Xiangtan.

2。Name Definition for the underlying data:

Select B1:D1, in the "Formula" (I take Excel 2010 as an example, if it is the 2003 version, the reason is similar), define the name as "Province"; Select B1:D4 and define the name in the Formula as well, and select the First Line from "Create from Selection".

3。Establish data validity in sheet2 table:

1) Build a "table header": A1 province, B1 city (manual input).

2) Create "province" validity: select A2 - data - data validity - set - (validity condition) allow - select "series" (ignore the null value and provide the lower arrow to tick) - ** - (input) = province - OK.

For rows below A2, select the A2 drop-down after the A2 validity is set.

3) Build "city" validity: select B2 - data - data validity - set - (validity condition) allow - select "sequence" (ignore null values and provide the lower arrow to tick) - ** - (input) = indirect(a2) - OK.

For rows below B2, select the B2 drop-down after the B2 validity is set.

ok！Let's see the effect, when you click A2 and the following rows in this column, a drop-down menu of "Zhejiang, Jiangsu, Hunan" will appear for selection;

For example, when A2 selects "Hunan", "Changsha, Zhuzhou, Xiangtan" appears in the drop-down menu in B2 for selection.

2. Click the cell that needs to add a drop-down option, then find [Data Validation] in the [Data] column and click it.

3. Select [Sequence] in the verification condition and <

In the ** column, select the required data directly and click OK.

This completes the one-level drop-down option.

4. For the second-level drop-down option, you must first define the entry, taking "Jiangsu Province" as an example. Select Jiangsu Province and its subordinate cities, and click [Formula].

5. Stand-alone [created according to the selected content].

6. Select "First Line" for the name, and then click Confirm.

7. Select the cell that needs the secondary drop-down option, and click [Data], then find [Data Validation] in the [Data] column and click it, the steps are the same as the second step.

8. Select [Sequence] in the verification conditions, enter =indirect() in the ** column, select the content to be referenced, remove the $ (lock symbol), and click OK to set the secondary drop-down option.

<>Join the community and learn together].

If you want to know more about Excel, we recommend consulting Miaoke Workplace. Miaoke Workplace will continue to invest in the research and development and upgrading of products and course content, actively expand more cutting-edge workplace courses, and explore the B-end enterprise training service market. "Second" stands for "minutes, seconds, moments", and "may" stands for "can, recognition", and Miaoke is committed to helping the majority of people in the workplace to learn and grow for life, gain recognition and achievement, and achieve common prosperity.

Excel has a powerful data collation and statistics function, which is a good helper for working and studying when you need to process data. Today I will share with you how to set the cell drop-down option in Excel.

1. First open Excel and open the workbook that needs to be processed. Select the cell for which you want to set the drop-down options, and click the Data page in the function list.

2. Continue to click the [Data Validation] option in the Data Tools group and select the [Data Validation] option from its drop-down list.

3. In the validation conditions of the [Data Validation] dialog box that pops up, switch [Any Value] to [Sequence].

4. After that, write the drop-down value that needs to be defined in the pop-up **, such as yes or no, and remember to separate it with English comma characters in the middle.

5. After setting, go back to the worksheet, pull down to fill, and the cell drop-down options for those selected areas are set.

Pre-enter the drop-down options in the blank space. Use the Drop-down List function on the Data tab to select Select Drop-down Options from Cells to select the drop-down options that have been pre-entered, detailed steps:

1. Enter in cell F2:F7: Administration Department, Human Resources Department, Logistics Department, Finance Department, Sales Department, Production Department.

2. Select cell C2:C16 and click the [Data] tab.

3. On the Data tab, click the [Drop-down List] function button, and the "Insert Drop-down List" dialog box will pop up.

4. In the Insert Drop-down List dialog box, click the circle and select Select Drop-down Options from Cell.

5. Click the button on the right side of the box to enter the data box.

6. Click the left mouse button and drag the mouse to select the data of cell f2:f7, and click the right button to return to the insert drop-down list dialog box.

7. Click the OK button to exit the dialog box and complete the setting of the drop-down list.

Excel settings drop-down options make it easier to enter data.

How do I set up drop-down options?

There are two ways to set up drop-down menus in Excel.

Here's how:

1. Open the file we need to set the drop-down box option, and click the office icon in the upper left corner.

2. Click on the side car in the drop-down menu to select "Excel Options".

3. In the Excel Options dialog box, click "Advanced" as indicated by the selection arrow.

4. Then select the "Show Paste Options Button" in the "Cut, Copy and Paste" option of the roll. Click the "OK" button.

5. At the same time, when setting the drop-down box options, be sure to select the added option part at the same time, and then click the "**" button in the upper right corner.

1. Open the software and find the content you need.

2. Select the first ** that is, A1 with the left mouse button, as shown in the following figure:

3. Put the mouse into the cell of A1, and hold down the left mouse button to pull down, so that the content in the selection list is realized, and the option to operate the content will appear when you left-click, as shown in the following figure:

Microsoft Excel is an electronic software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The intuitive interface, excellent calculation capabilities, and charting tools, combined with successful marketing, make Excel the most popular data processing software for personal computers. With the release of Excel in 1993 as a component of Microsoft Office, Excel began to dominate spreadsheet software on all operating platforms.

1. Open Excel** on the computer.

2. After opening the excel sheet, click to enter the data page.

3. On the data page, click Data Verification.

4. After entering the data verification page, allow the selection of the sequence, and then directly select the cells in **.

5. After the verification of the digital and silver model, there will be a downward icon on the right side of the cell, click to select the content.