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 ...

Open an Excel sheet and select a column. Navigate to Data > Data Tools > Data Validation. Select List type, click the up ...

How to embed a data validation control in Excel. ... Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.

1: Creating a Dynamic Data Validation List. A dynamic data validation list is the foundation of any interactive drill-down functionality. It enables users to filter and summarize data by selecting ...

In Word 2003, choose Validation from the Data menu. When Excel displays the warning message, click OK to delete the validation settings for both ranges. Click Cancel if you don’t want to delete ...