Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.