Step 1: Open the excel document and select the cell to be added with the drop-down option.

Step 2: Click Data in the menu->; "data validity"->; "data validity".

Step 3: In the pop-up page, under the Settings menu, click Allow and select the Sequence button.

Step 4: Enter the drop-down options to be set in the cells in the source, separated by English commas, and then click OK.

We can get the effect we want.