Skip to search results
PRODUCT
Office.com results
Insert or delete a drop-down list
Article To make data entry easier in Excel 2007, or to limit entries to certain items that you define, you can insert a drop-down list of valid entries. You can also de...
Excel 2007
Use validation to create dependent lists
Article By Bill Jelen Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com , whi...
Excel 2007
Find cells that have data validation
Article Find cells that contain data validation criteria, find cells that contain identical validation criteria.
Excel 2010, Excel 2007
Remove data validation
Article You can remove validation on a cell in Excel 2007 so that users are no longer required to enter information or information formatted in specific way.
Excel 2010, Excel 2007
Copy data validation settings
Article After you define data validation in a cell, you may want to copy the data validation settings to other cells. For example, you may want to ensure that a user ca...
Excel 2007
Display or hide circles around invalid data
Article Data validation is designed to display messages and prevent invalid entries only when users type data directly in a cell. Validation messages won't appear and...
Excel 2007
Apply data validation to cells
Article Use data validation to control the type of data or the values that users enter into a cell. One example of restricting data is a drop-down list.
Excel 2007
Video: Create a drop-down list
Article To make data entry easier in Excel 2007, or to limit entries to certain items that you define, you can insert a drop-down list of valid entries. You can also de...
Excel 2007
Didn't find what you were looking for?Search all of Office.com