This example describes how to create dependent drop-down lists in Excel. Here’s what we are trying to achieve: The user selects Pizza from a drop-down list. As a result, a second drop-down list contains the Pizza items. To create these dependent drop-down lists, execute the following steps. 1. On the second sheet, create the following […]
Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values. 1. On the second sheet, type the items you want to appear in the drop-down list. 2. On the first sheet, select cell B1. 3. On the Data tab, […]
This example teaches you how to use data validation to prevent users from entering incorrect product codes. 1. Select the range A2:A7. 2. On the Data tab, click Data Validation. 3. In the Allow list, click Custom. 4. In the Formula box, enter the formula shown below and click OK. Explanation: this AND function has […]
This example teaches you how to use data validation to prevent users from entering duplicate values. 1. Select the range A2:A20. 2. On the Data tab, click Data Validation. 3. In the Allow list, click Custom. 4. In the Formula box, enter the formula shown below and click OK. Explanation: The COUNTIF function takes two […]
This example teaches you how to use data validation to prevent users from exceeding a budget limit. 1. Select the range B2:B8. Note: cell B10 contains a SUM function that calculates the sum of the range B2:B8. 2. On the Data tab, click Data Validation. 3. In the Allow list, click Custom. 4. In the […]
This example teaches you how to use data validation to reject invalid dates. 1. Select the range A2:A4. 2. On the Data tab, click Data Validation. Outside a Date Range 3. In the Allow list, click Date. 4. In the Data list, click between. 5. Enter the Start date and End date shown below and […]
Use data validation in Excel to make sure that users enter certain values into a cell.Data Validation Example In this example, we restrict users to enter a whole number between 0 and 10. Create Data Validation Rule To create the data validation rule, execute the following steps. 1. Select cell C2. 2. On the Data […]
