But this time, we don’t have to type in the departments – they are listed in column G.Ĭlick on the drop-down next to Criteria and choose List from a Range. We are now going to add a dropdown to the Department Column. If you try and enter incorrect data, as soon as you press enter you’ll see the help text appear: You should now see your list when you click on the drop-down in cell B2. (For example “Choose day from list please” or “Click and enter a value from the list of items”) This means that the user will be warned that they are entering data that isn’t expected.įinally, you can add some validation help text.
If you think there might be a time when someone needs to input an option that isn’t part of the drop-down list, then choose Show Warning. If you don’t want any invalid data entered (and I don’t!) choose the Reject Input option. Make sure there is a tick in the Show drop-down list in cell boxĭecide how you want to handle invalid data. (For example, Monday,Tuesday,Wednesday,Thursday,Friday) Type in the options you want to display in your drop-down, separated by commas.
(If it’s not, click on the select data range icon, highlight the cells you want to add a drop-down to, then click OK)Ĭlick on the drop-down next to Criteria and choose List of Items. Make sure the cell range here is correct. Click on the Data Tab, and choose Data Validation.
0 kommentar(er)
