Data Validation with a List - Only allow values contained in a list to be entered into a cell

http://www.TeachMsOffice.com

This tutorial will show you how to prevent a user from entering a value in a cell in excel which is not contained in a list. This will teach you how to make it so that a cell can only contain the values, characters, text, words, etc. that are in a list. This is not a drop-down list. You will also learn how to keep this list on a separate tab.

This feature in Microsoft Excel is called Data Validation and data validation prevents a user from entering certain values or text in a cell or multiple cells.


To get the spreadsheet used here of for more excel video tutorials, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.

Have a great day!

Category:

Education

Tags:

• microsoft
• excel
• data
• validation
• static
• list
• cell
• dependent
• on
• lists
• enter
• certain
• values
• only
• separate
• prevent
• words
• numbers
• being
• entered
• into

[ExcelisHell]

Glad to help:D

[tirathmistry]

Awesome tutorial

Thanks So much for your Great tutorial

Thanks God Bless you :)