Excel Forum

Allow only values contained in a list to be entered into a cell - Data Validation

This Excel video tutorial shows you how to use Data Validation to prevent a user from entering a value or word into a cell unless that value or word is already contained in a list. Basically, this prevents a user from entering a value that you do not want them entering. So, only what is in a list, specified by you, is what can be entered into this cell.

This is a cool feature to use; especially in forms or excel spreadsheets that you send out to people in order that it be filled out. It helps to prevent user errors.
   Topics Covered
Prevent Values/Characters/Words from Being Entered into a List
Allow only Pre-specified Values to be Entered into a Cell
Data Validation in Excel
Working with Lists
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.