How to set excel drop-down options Tips for setting excel drop-down options

Some survey-type excel tables can be selected through the drop-down menu. The excel drop-down menu allows you to execl cells through settings. You only need to click with the mouse to select some content and input it into the cell without manual input. So how to make an excel drop-down menu? Let’s take a look below. Recovery method 1. First, open the Excel file that needs to set the drop-down selection items on the computer, and enter the content of the shameful selection items.

2. Select the cell where the drop-down options need to be set, click the "Data" menu, and select "Data Verification".

3. Then the "Data Validation" dialog box pops up, select "Sequence" under "Validation Conditions", and check "Ignore NULL Values" and "Provide Drop-Down Arrows".

4. Select the set drop-down options in the "Source" Yangchuan input box and click "OK".

5. At this time, a drop-down arrow will appear under cell B3, and all options will appear in the drop-down list. Just select the appropriate option.

The above is the detailed content of How to set excel drop-down options Tips for setting excel drop-down options. For more information, please follow other related articles on the PHP Chinese website!