Select a cell — I selected B2. Click the Data tab. In the Data Tools group, click Data Validation, and then click Data Validation from the dropdown. From the Allow dropdown, choose List.

Go to Data on the Ribbon, and in the Data Tools group, choose Data Validation. The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole ...

Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A, click B2. Feel free to use one of your own files if you like or choose another cell.

Pydantic, the popular Python library and open source data-validation framework used by some of the world’s biggest companies, has a new commercial namesake and the backing of one of Silicon ...