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?

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

The core problem: Using the indirect function to set the validity of the next-level data, an error message 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)

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

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.

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!