Home  >  Article  >  Topics  >  What should I do if "The list source must be a demarcated data list" appears?

What should I do if "The list source must be a demarcated data list" appears?

藏色散人
藏色散人Original
2020-04-15 09:18:1143615browse

What should I do if

What should I do if "The list source must be a demarcated data list" appears?

The list source must be a demarcated data list. Error resolution

Prerequisite 1: The data sources to be quoted have been sorted out

Recommendation: "Excel Tutorial

Prerequisite 2: The "name" and "first-level drop-down menu" have been set up (you can't do this on Baidu yourself)

Just give me a simple one For example, as shown below, the province's validity setting is completed

What should I do if The list source must be a demarcated data list appears?

The core problem: Using the indirect function to set the validity of the next-level data, an error message appears

What should I do if The list source must be a demarcated data list appears?

Solution: When setting the validity of the second-level "city", you must first select a value in the first cell under the first-level "province" (choose any one, it is not important) , will be deleted later)

What should I do if The list source must be a demarcated data list appears?

Next step: Then just like the third step, use the indirect function to set the data validity. At this time, click "OK". No error message will appear

What should I do if The list source must be a demarcated data list appears?

Finally: delete the cell where you just entered the value casually, set it up, and then you can enter the real data according to actual needs.

What should I do if The list source must be a demarcated data list appears?

The above is the detailed content of What should I do if "The list source must be a demarcated data list" appears?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn