How to do the excel20 17 drop-down menu?

How to make an excel drop-down menu and how to create an excel drop-down menu. How to do a drop-down in an excel table? As we all know, after doing a drop-down of common words, we can be lazy occasionally and don't need to input these common words. Let me talk about how to do it and how to create an excel drop-down menu.

Methods/steps

1

First create a new table, and then click Open it.

2

Click to open the form and enter the editing state of the form.

three

After entering the editing state, we found and clicked the "data" option in the table navigation.

four

After finding the data option, we select the cell as the drop-down menu.

five

After selecting the cell to drop down, I click the "Validity" option under Data Options.

six

Click the option to enter the data validity setting window.

seven

In the data validity setting window, we set the "Allow" option in the window to "Order", and pay attention to whether there is a √ before the "Provide drop-down arrow". If not, please tick.

eight

Then, we enter the drop-down menu words we want to do in the "Source" option. For example, enter "Test 1, Test 2, Test 3" here, and remember to separate words with commas (in English input mode, commas are used). Then click OK.

nine

Finally, go back to the table and see if there is a drop-down menu.