Tool: 20 10 excel

1. Open excel first. Take the following figure as an example. First, select all the columns A for which options need to be set.

2. Click "Data" above the start menu bar, then click the "Data Validity" drop-down arrow and select "Data Validity";

3. Click the drop-down arrow in the setting interface, and then select "Sequence";

4. Then enter the five options you want to set in the source box, such as "1, 2,3,4,5". Pay attention to enter commas in English, and finally click "OK";

5. After returning to the main interface, click the drop-down arrow on the right side of the cell, and five options will appear to choose from.