Please click to enter a picture description.
Select the cell where you want to set the drop-down menu.
Please click to enter a picture description.
Click the Data tab at the top of the toolbar.
Please click to enter a picture description.
Select the Insert drop-down list option in the Data tab.
Please click to enter a picture description.
Enter the first option of the drop-down menu in the Insert drop-down list window.
Please click to enter a picture description.
Click the Add button in the upper right corner of the Insert drop-down list window.
Please click to enter a picture description.
Enter the second option in the drop-down list and click OK.
Please click to enter a picture description.
An inverted triangle will appear on the right side of the cell. Click the inverted triangle, and the selection menu we set will appear.
Please click to enter a picture description.
The final result is shown in the figure.
Please click to enter a picture description.