Home >Topics >excel >What should I do if the input content in Excel does not meet the restrictions?

What should I do if the input content in Excel does not meet the restrictions?

王林
王林Original
2020-04-10 13:18:3975983browse

What should I do if the input content in Excel does not meet the restrictions?

1. First open the Excel table that needs to be edited and enter the editing page.

2. Then select the cell and click "Data Validation".

What should I do if the input content in Excel does not meet the restrictions?

#3. Then click to open "Data Validation" in the pop-up window.
What should I do if the input content in Excel does not meet the restrictions?

4. Then click to select "Clear All" in the error warning in the pop-up window, and press Enter to confirm.

What should I do if the input content in Excel does not meet the restrictions?

Recommended tutorial: excel tutorial

The above is the detailed content of What should I do if the input content in Excel does not meet the restrictions?. 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