We can prevent invalid data from being entered into a cell
when using Microsoft Excel 2010. You can reject invalid entries and also force
entries to be chosen from a dropdown list of values that the author specified.
Here’s how you do it.
1. Open up your working spreadsheet file.
2.
Point to the cell that you want to have data
validation.
3.
Click on the Data tab > Data Validation > Data Validation
4. You should be able to see the available validation options that you can use.
5. The validation parameters that I've set as an
example are shown in the screen shot below.
Now you have a simple checking tool to see if you're inputting the correct values into your excel files. I hope this is as useful to you as it was to me.
No comments:
Post a Comment