One: Take the WPS EXCEL table as an example, the operation of the window office execl table is the same. First, we enter the words "drop-down menu test" in the form. Of course, it doesn't matter whether we enter text here or not.

Two: Then we select the cell, that is, the cell where the text is entered.

Third, find the "data" option from the function key at the top of the table and open it. If it is a window office execl table, a "data" drop-down list will pop up, while WPS will be displayed directly below, and the drop-down list will not pop up.

4. Find "Auto Filter" from the data options (first find "Filter" from the data options and then find "Auto Filter" from "Filter" in the office execl table of the window), and then click it to complete the drop-down menu setting.

Finally, you can set the drop-down menu according to your own needs.