On the worksheet where you applied the drop-down list, select a cell that has the drop-down list. Go to Data > Data Validation. On the Settings tab, click in the Source box, and then change …

Add data validation. Change a data validation condition. Remove data validation. Ways that users are notified about validation errors. For a form that is designed to be filled out by using …

Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). …

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 …

To modify the list of valid entries, simply change the values in the source list or edit the range in the Source box. You can specify your own error message to respond to invalid data inputs. On …

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 …

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 …

With built-in custom lists, you can sort data—either by days of the week or months of the year. Optionally, you can create your own custom lists to sort by any other characteristic that doesn’t …

Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.

Add a list box to your Excel worksheet from which users can choose a value. Make data entry easier by letting users choose a value from a combo box. A combo box combines a text box …