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 dropdown 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
/ 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: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial