Excel - data validation

Data validation in Excel is similar to forms in Word. When we created forms in Word, we wanted to control what information the user entered. Similarly in Excel, we use data validation to control the kind of information someone can enter into our worksheet or template.

Online Resources

• tinyurl.com/i0th - video demos on our website
  
• YouTube.com - various video tutorials
  
• YouTube video demo - create a drop-down list
  
• Microsoft - Using other validation tools in Excel
  
• Microsoft - Control user choices with drop-down lists in Excel
  
• Microsoft - overview and samples of data validation
  
• Ozgrid.com
  
• ExcelTips - several topics on data validation