Excel2016 sets the method to enter non-sequential content and ask whether to enter:

1. Start Excel and open the worksheet, select the cells for which data validation needs to be set in the worksheet, open the "Data Validation" dialog box, select the "Sequence" option in the "Allow" drop-down list of the "Settings" tab, and Directly enter the data sequence allowed in the "Source" text box, as shown in Figure 1.

2. Open the "Error Warning" tab, select the "Warning" option in the "Style" drop-down list, set the "Title" and "Error Message" of the warning, and click the "OK" button to close the dialog box after completing the settings, as shown in the figure 2 shown.

3. Enter non-data sequence data into a cell with data validation set, and after pressing the Enter key, Excel will pop up a warning dialog box. If you want to enter the data, click the "Yes" button in the dialog box; if you do not want to enter the data, click the "No" button, the data in the cell will be selected, and the user can directly modify the data. , as shown in Figure 3.

Summary: The above is all the content. If you want to know more about excel2016, you can continue to pay attention to the updated content of our website.