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

You can remove the Data Validation restrictions from a cell or a range of cells by opening the Data Validation window. Select the cell or the range of cells and go to Data > Data Validation .

Excel has built-in tools to expose and even delete duplicates, but they work on existing data after the fact. ... There’s no built-in duplicate rule for Excel’s Data Validation feature, ...

Under the Data tab, click on Data Validation. 2. In the settings tab of the pop-up window, under Source, add or delete list items as necessary, making sure all items are separated with a comma and ...