How to set multiple contents in excel data validity

How to set multiple contents for excel data validity?

In the data validation interface of the EXCEL table, you can add multiple options to a single cell. Please refer to the following steps for specific operations.

Recommended: "excel tutorial"

1. First open an EXCEL file on your computer, then select the target cell and click "Data" in the upper toolbar options.

#2. Then in the options page that appears, click the drop-down arrow next to "Data Validity".

#3. Then click the "Data Validity" option in the drop-down box that appears.

#4. Then select "Sequence" in the allowed settings area, and enter the option content in the edit bar below the "Source" area.

#5. After completing the above settings, you can add multiple options to a single cell in the Excel table.

The above is the detailed content of How to set multiple contents in excel data validity. For more information, please follow other related articles on the PHP Chinese website!