Home >Topic List >Excel input value is illegal
Excel input value is illegal
In Excel, when the entered value is illegal, there are several ways to deal with it. This topic provides you with articles related to illegal input values in Excel. You can try it for free.
Solution to illegal input value in excelSolution to illegal input value in Excel: 1. Check whether the entered value meets the requirements, and set a warning or error prompt in Excel through conditional formatting or data verification function to remind the user to re-enter the correct value; 2. Use the data verification function to Set constraints such as the range, type, and length of the value, and Excel will automatically give an error message; 3. Use the IF function to make conditional judgments, and provide corresponding processing methods based on the results of the conditions; 4. Use conditional formatting to mark, so that Illegal values are displayed in different styles.
How to solve illegal input values in Excel tableThe solution to the illegal input value in the excel table: first enter a data in the cell to be modified; then select the cell and select the data "validity" in the menu; then modify the maximum value in the settings; finally cancel the error warning checkbox.
Related coursesMore>
Become a PHP Architect - Homemade PHP FrameworkIntermediate18181 plays
Learn Python and play with Excel in 2 hours to achieve efficient office automationElementary10836 plays
Ideal video tutorial website front-end page video tutorialAdvanced415634 plays
Geek Academy AngularJS video tutorialAdvanced54125 plays
Related Resource DownloadsMore>
Related TutorialsMore>
- 04-13
- 01-13
- 03-06
- 03-05
- 06-05
- 06-01