Current location - Trademark Inquiry Complete Network - Trademark registration - How to add options to excel tables? For example, I set the column of "Project Type", and I need five options, which I can choose when filling out the form.
How to add options to excel tables? For example, I set the column of "Project Type", and I need five options, which I can choose when filling out the form.
It can be realized by data validity in excel, and the operation steps are as follows:

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.