How to Validate Data in Microsoft ExcelPosted: December 6, 2010
Barb was out at Eastern Health on Friday doing an Intermediate Excel course. The attendees wanted to do some work on data validation and while the manual contained the basics of validation, they needed more. So Barbie very graciously wrote this 9 page handout over the weekend, which I share with you all now. Data Validation in Excel
Ah, but what is data validation you ask?
Well, Data Validation allows you to restrict the data entered into a range of cells in an Excel worksheet. For example, if you have created a worksheet that others use, you need to ensure that only data that matches your requirements is entered into those cells, perhaps a range of numbers (e.g. between 10 and 20), or only specific text (e.g., Mr., Mrs, or Miss).