Loading...

Data validation - whole number
Key Stage 4
Year 11
Computing
Okay, so the Score column, column C here should only allow values between 1 and 10. We can ensure that a user only enters a score between 1 and 10 by adding a data validation rule. I've selected the cells C2 to C9. I'm then going to go to Data and Data Validation. I'm going to add a new rule for these cells. It's automatically selected that I can do a dropdown list here, and I'm going to keep it as that for now. But rather than option one, I'm going to replace it and say one, I'm then two, and then going to add another item for three and four and so on until I get down to 10, because we only want the scores from 1 to 10. So once I have added all of those in, we've now got those as allowed values. Now, this will work fine as a validation and I can have it as a dropdown box, and that will stop a user from entering anything that's not between 1 and 10. But actually for this cell, I'd like the user to just be able to type in the number. So what I'm going to do is I'm gonna scroll down to where it says Advanced options here, and then scroll down a little bit further, and I'm gonna change the display style. So it's currently set to Chip. I can change it to Arrow, which will get rid of the kind of lozenge shape and just put an arrow on the edge of the cell. Or I can change it to plain text, which is what I'm going to do here, which means that the user can just type in the value, but it still has to be one of the values from my dropdown list here. So once that's done and I've selected Done, I can move away from the validation rules. And now if I go to starting adding the scores, so for example three for the first score, hit Enter, that's absolutely fine. If I was to add zero though and move away, you can see that I get a validation message to say that the data I've entered violates the data validation rule, and it won't allow me to enter anything that isn't a score between 1 and 10.
Data validation - whole number
Key Stage 4
Year 11
Computing
Okay, so the Score column, column C here should only allow values between 1 and 10. We can ensure that a user only enters a score between 1 and 10 by adding a data validation rule. I've selected the cells C2 to C9. I'm then going to go to Data and Data Validation. I'm going to add a new rule for these cells. It's automatically selected that I can do a dropdown list here, and I'm going to keep it as that for now. But rather than option one, I'm going to replace it and say one, I'm then two, and then going to add another item for three and four and so on until I get down to 10, because we only want the scores from 1 to 10. So once I have added all of those in, we've now got those as allowed values. Now, this will work fine as a validation and I can have it as a dropdown box, and that will stop a user from entering anything that's not between 1 and 10. But actually for this cell, I'd like the user to just be able to type in the number. So what I'm going to do is I'm gonna scroll down to where it says Advanced options here, and then scroll down a little bit further, and I'm gonna change the display style. So it's currently set to Chip. I can change it to Arrow, which will get rid of the kind of lozenge shape and just put an arrow on the edge of the cell. Or I can change it to plain text, which is what I'm going to do here, which means that the user can just type in the value, but it still has to be one of the values from my dropdown list here. So once that's done and I've selected Done, I can move away from the validation rules. And now if I go to starting adding the scores, so for example three for the first score, hit Enter, that's absolutely fine. If I was to add zero though and move away, you can see that I get a validation message to say that the data I've entered violates the data validation rule, and it won't allow me to enter anything that isn't a score between 1 and 10.