Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list.

You can use data validation to restrict the type of data or values that users enter into cells. This is an advanced topic on data validation. For an introduction to data validation, and how to …

Add data validation. Click the control that you want to add data validation to. On the Format menu, click Data Validation. In the Data Validation dialog box, click Add. Under If this condition is …

You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.

You can find cells in a workbook that contain data validation by using the Go To Special dialog box. On the Edit menu, point to Find, and then click Go To. Click Special. Select Data …

Go to Data > Data Validation. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing …

On the Data tab, in the Data Tools group, click the arrow next to Data Validation, and then click Circle Invalid Data. Excel displays a red circle around any cells that contain invalid data. All …

You can use the Validation Rule property and the Validation Text property of a form control to validate data that is input to that control and to help users who input data that is not valid. Tip: …

How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.

To remove a drop-down list, click the cell with the list, then click Data > Data Validation, and then on the Settings tab, click Clear All, then OK. A drop-down list is also known as a drop-down …