Feature Summary

The Data Validation (Data Verification) feature is used to control and standardize cell input. It can restrict input ranges, create drop-down lists, and set input prompts and error alerts, preventing invalid data at the source and improving entry efficiency and accuracy.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Setting Data Validation

Feature Entry
"Data" tab → "Validation" button

  1. Select the cells for which you want to set rules
  2. Click the "Validation" button in the Data tab
  3. In the pop-up settings window, select the allowed input type and set conditions as needed
  4. Customize input prompts and error alerts
  5. Click OK to apply

image

Circle Invalid Data

Feature Entry
"Data" tab → Drop-down menu under the "Validation" button → "Circle Invalid Data" button

  1. Select the cells you want to check for compliance with data validation rules
  2. Click the Data tab
  3. Click the Validation drop-down menu
  4. Click the "Circle Invalid Data" button
  5. Automatically detect and mark cells that do not comply with data validation rules, making it easy to quickly locate erroneous data

image

Clear Validation Circles

Feature Entry
"Data" tab → Drop-down menu under the "Validation" button → "Clear Validation Circles" button

  1. Select the marked cells that do not comply with the rules
  2. Click the Data tab
  3. Click the Validation drop-down menu
  4. Click the "Clear Validation Circles" button
  5. Remove all invalid data marks without affecting the data itself

image

Frequently Asked Questions

Q1: How to only prompt without blocking invalid input?

  • Solution: In the error alert style, select "Warning" or "Information" to only prompt without blocking the input.

Q2: What should I do if I set up data validation but don't want the drop-down arrow to appear?

  • Solution: In the data validation settings, uncheck the "Provide drop-down arrow" option.

Q3: What should I do when the input content prompts "Does not meet the restriction conditions"?

  • Solution: Delete the entered content, click to select the cell to view the drop-down arrow or open the data validation window, check the set restriction conditions, and modify the input content accordingly.

Notes

  • Data validation can set input prompt messages to help users understand input requirements
  • Clearing data validation: Select the area where validation has been set, open the data validation window, and click "Clear All" to remove the rules