Data validation from another sheet


Excel 2007 - Data validation list from another worksheet Hi everyone, I am creating lists using data validation in Excel 2007 and want to put the list options on a separate sheet to make sure they don't get accidentally deleted/altered. excel 2007 wont allow you to reference another sheet for DV or CF, you have to create a named range on the other sheet, and then use that name in the DV window. excel 2007 wont allow you to reference another sheet for DV or CF, you have to create a named range on the other sheet, and then use that name in the DV window. Data Validation is a feature in Microsoft Excel which restricts the values or type of data that users enter into a cell. It automatically checks whether the value entered is allowed based on the specified criteria. To quickly remove data validation for a cell, select it, and then go to Data > Data Tools > Data Validation > Settings > Clear All. To find the cells on the worksheet that have data validation, on the Home tab, in the Editing group, click Find & Select, and then click Data Validation. After you have found the cells that have data validation ...