Premium Only Content

HOW TO SET DATA VALIDATION RULES
You can control the type of data to be entered into your worksheet with the use of Data Validation in Excel. This video will show you how to set validation rules.
Excel Data Validation allows you to limit data entries to the dropdown list and restricts data outside of the range. There are eight options available to validate the input:
1. Any Value – this is the default if no validation rule is set.
2. Whole Number – if data entry is limited to whole numbers or only whole numbers are allowed. If this validation rule is selected, other validation options have to be defined to further limit the input, such as between, not between, equal to, not equal to, greater than, less than, greater than or equal to and less than or equal to.
3. Decimal – is similar to Whole Number option but allows decimal values within the range given.
4. List – allows only values from a predefined list and presented to the user as a dropdown menu control.
5. Date – only dates are allowed.
6. Time – data entry is limited to times only.
7. Text Length – validates entry based on the number of characters or digits.
8. Custom – validates input using a custom formula.
This function can be found under the Data tab and the keyboard shortcut for this Excel function is also introduced in this video.
Title: How to Set Data Validation Rules
#datavalidation #howtosetdatavalidationrules
-
LIVE
TimcastIRL
54 minutes agoEPSTEIN Files DROP, FBI GOES ROGUE, AG Says They COVERED UP Epstein Case w/Amber Duke | Timcast IRL
18,740 watching -
LIVE
Kim Iversen
1 hour ago"Canada's Trump" Is Trudeau’s Worst Nightmare: Is Maxime Bernier the Future of Canada?
1,475 watching -
DVR
Bannons War Room
10 days agoWarRoom Live
2.58M435 -
16:06
The Rubin Report
7 hours agoProof the Islamist Threat in England Can No Longer Be Ignored | Winston Marshall
34.3K24 -
2:07:07
Robert Gouveia
4 hours agoFBI Files Coverup! Bondi FURIOUS; SCOTUS Stops Judge; Special Counsel; FBI Does
40.5K31 -
56:15
Candace Show Podcast
5 hours agoBREAKING: My FIRST Prison Phone Call With Harvey Weinstein | Candace Ep 153
107K69 -
LIVE
megimu32
1 hour agoON THE SUBJECT: The Epstein List & Disney Channel Original Movies Nostalgia!!
190 watching -
9:06
Colion Noir
10 hours agoKid With Gun Shoots & Kills 2 Armed Robbers During Home Invasion
16.9K3 -
54:28
LFA TV
1 day agoUnjust Man | TRUMPET DAILY 2.27.25 7PM
19.7K2 -
DVR
CatfishedOnline
7 hours ago $1.19 earnedGoing Live With Allen Weekly Recap
21.8K