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
-
16:24
T-SPLY
19 hours agoArrested Judge Demands Immunity And Case Dropped For DHS Obstruction!
845K148 -
14:07
Mrgunsngear
1 day ago $52.45 earnedStreamlight MegaStream USB EDC Flashlight Review 🔦
129K14 -
7:43:57
SpartakusLIVE
12 hours agoNEW MODE || Massive Resurgence || Friday Night HYPE
58.9K1 -
2:03:18
TimcastIRL
10 hours agoBiden Special Counsel Audio LEAKS His Brain Was FRIED Democrats COVERED IT UP | Timcast IRL
655K119 -
1:18:49
Man in America
14 hours agoEXPOSED: Big Pharma’s Sinister Takeover of the Cannabis Industry w/ Inesa Ponomariovaite
60.8K23 -
1:26:25
FreshandFit
11 hours agoThe Current State Of The Manosphere w/ Rollo Tomassi
97.6K21 -
2:50:39
I_Came_With_Fire_Podcast
19 hours agoCOMEY GOING TO JAIL | CHINESE KILL SWITCHES | BIRTHRIGHT CITIZENSHIP
46.2K11 -
3:54:07
SynthTrax & DJ Cheezus Livestreams
1 day agoFriday Night Synthwave 80s 90s Electronica and more DJ MIX Livestream AI ART SHOWCASE Edition
57.5K8 -
2:21:34
TheSaltyCracker
11 hours agoThreatening Trump is Bad Idea ReeEEEStream 05-16-25
153K234 -
4:08:03
Saycred Angel Live
9 hours ago🍻FRIDAY FAMILY FIGHT NIGHT🍻!TANGIA | !GIVEAWA
50.9K4