How to Allow Only Certain Values in Excel Using Data Validation

Sometimes we need to restrict data range for specific values. It could be yes/no answers or even certain text/numbers or even characters. This is why in this advanced excel tutorial i'm about to show you how you can allow only yes or no entry in excel. You can also say we are restricting data range or rows or columns to enter only specific values. Hope you can use your imagination and solve versatile problems using this excel tutorial. Lets get started.
Step 1: First select the data range where you want to use data validation.
Step 2: Now click on "Data" tab and click on "Data Validation"
Step 3: Now under the Validation criteria click on the drop-down list where you have predefined "Any Value".
Step 4: Select "Custom" and you'll find a formula bar.
Step 5: Inside the formula bar write this formula =(OR(A1="Yes",A1="No"))
Step 6: Click Ok and Done. Now you can only enter yes or no data in column A

Special Note: 1. In the formula A1 indicates the first cell of selected column
2. Yes/No is the text i want to allow on the selected data range.
Change 1 & 2 according to your need.

Now you know how to allow only certain values in Excel using data validation.

Thanks for watching.
#DataValidation #Yes/NoAnswer
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join

Видео How to Allow Only Certain Values in Excel Using Data Validation канала Excel 10 tutorial