How does Excel set clear data validation?

Source: Internet
Author: User

How does Excel set clear data validation? The validity of the data is set in the table, and we will not be able to fill in any other error. Modify the table to determine the validity of the data, it is necessary to clear the data validation settings, the following small series for you to introduce, to see!


Fill in the content failed, but we are sure that we fill in the content without errors.

Select the cells you want to modify and click the data in the main menu-data validation. In the bottom left corner of the pop-up menu there is "all clear", click OK.

In the file more than set the validity, we do not need the entire document, the deletion efficiency is too slow. We use positioning to select all the cells that have data validation settings. In the Start menu-Find and select-position criteria. or shortcut key ctrl+g, pop-up positioning menu, click on positioning conditions.

Select the data validation in the Location menu-all, click OK.

In this way, the cells that have validity settings in the file are all selected.

We're going to click on the data Validation menu at this point and pop up the "Select area contains multiple data validation" prompt box, OK.

When the Data validation menu pops up, it's slightly different when you know a cell, or the same click Setting-all clear so that all the validation settings in the entire file are deleted.

The above is how to set up a clear data validation method Introduction, the operation is very simple, we have learned? I hope this article can help!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.