How do I set the input data type limit for Excel cells?

1. Select the cells that you want to set up data validation, such as the E3 cell here. Open the Data Validation dialog box and set the validation criteria on the Settings tab. Here, in the Allow Drop-down list, select the Custom option, enter the formula =isnumber (E3) in the Formula text box, as shown in Figure 1, and set the cell input prompt in the Input Information tab. As shown in Figure 2, the error message is set on the Error Alert tab, as shown in Figure 3. When you finish setting up, click OK to close the dialog box.

Ways to restrict the type of data entered in cells in an Excel worksheet

Figure 1 Setting the Allow condition

Ways to restrict the type of data entered in cells in an Excel worksheet

Figure 2 Setting the input information

Ways to restrict the type of data entered in cells in an Excel worksheet

Figure 3 Setting Error notification information

Tips

The E3 in the formula is the address of the cell that requires input restrictions, the isnumber () function is used to determine whether the data in the cell is a number, and if so, returns false.

2, select the set of data validation of the cell will get the prompt information, as shown in Figure 4. When the input data type and settings are not the same, Excel gives a hint, as shown in Figure 5. If you need to limit the input of other cells in the column, simply drag the fill handle with the mouse to copy the formatting to the other cells, as shown in Figure 6.

Ways to restrict the type of data entered in cells in an Excel worksheet

Figure 4 Tips for selecting a cell

Ways to restrict the type of data entered in cells in an Excel worksheet

Figure 5 Message when you enter an error

Ways to restrict the type of data entered in cells in an Excel worksheet

Figure 6 Copying the input restrictions on a cell