EXCEL uses the data validity sequence to implement the drop-down list method

Method 1

1. Open the worksheet in EXCEL and select the area or whole row or whole column to be set:

2. Click "data validity" in the "data" functional area:

3. In the pop-up "data validity" dialog box, under the "Settings" tab, select "sequence" under "allow ":

4. Set whether to ignore null values as needed. In the "source" text box below, enter the list items to be selected. Each value is separated by a comma and no quotation marks are required, click OK again:

5. Return to the worksheet. The selected area has a drop-down arrow. Click this arrow or press the ALT key to bring up the drop-down list:

6. If the following data is the same as the current cell data, we can point the cursor to the point in the lower right corner of the cell selection box (black box, you can double-click the icon to fill the configuration:

The data validity drop-down arrow disappears. Solution:

1. Check Excel option settings

In some cases, the drop-down arrow of data validity may be hidden because all objects in the workbook are hidden. In this case, the object hiding is canceled through the settings below.

Excel 2003: Click "Tools & rarr; options & rarr; View" in the menu, select "show all" under "object", and click "OK.

Excel 2010/2013: Select "file & rarr; option & rarr; advanced". Under "show options for this workbook", set "show for objects:" to "all ".
2. Change the data validity settings

If the "provide drop-down arrow" option is not selected when setting the data validity, no drop-down arrow is displayed. Modify the settings here.

3. Move a worksheet

Open the workbook with Excel 2007/2010/2013, right-click the worksheet tab, and select "move or copy" to move the worksheet without the data validity drop-down arrow or copy it to another Workbook, this problem can also be solved.
4. Use the Excel 2003 restoration function

Save the workbook as xls, and then click File & rarr; open in Excel 2003 or click open in the toolbar, in the open dialog box, select the problematic Workbook, click the arrow next to the open button, and select open and repair ".

5. In the displayed dialog box, click "repair". Excel 2003 will automatically fix the above problems.