Feature Summary

The Data Validation feature is used to control and standardize cell input. It allows you to 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. You can customize input prompts and error alerts
  5. Click OK to apply

截图

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 detects and marks cells that do not comply with data validation rules, making it easy to quickly locate erroneous data

截图

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. Removes all invalid data marks without affecting the data itself

截图

Frequently Asked Questions

Q1: How can I 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 data validation but don't want the drop-down arrow to appear?

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

Q3: What should I do if 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 it has been set, open the data validation window, and click "Clear All" to remove the rules