How to add and find options and table options in Excel

Recently, the editor has received a lot of private messages in the backend of this site. Many friends have come to this site to ask me how to add excel options. The editor was not clear at first, so I collected relevant information online and finally found it. Here is an introduction to where the excel table options are. The specific content is in the article below. If you need it, please come to this site to take a look.

How to add excel options?

The specific steps are as follows:

1. Select the cell range where you want to add drop-down options;

2. Click the [Data Validation] option under [Data Validation] in the [Data] tab;

3. In the pop-up "Data Validation" dialog box, select [Sequence] in the "Allow" drop-down list, and then enter the options in the drop-down list in the "Source" field. Separate the options with English commas. Finally click [OK];

4. After completing the above settings, a drop-down list will appear when you click the mouse in the cell. You only need to select the required options. That’s it.

The above is the detailed content of How to add and find options and table options in Excel. For more information, please follow other related articles on the PHP Chinese website!