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
Man in America
5 hours agoDollar Collapse is Engineered to Herd Us Into CBDC Prison—David Jensen EXPOSES the Playbook
434 watching -
MattMorseTV
5 hours ago $5.03 earned🔴CHILLING + TALKING🔴
60.2K2 -
2:04:23
The Charlie Kirk Show
2 hours agoTHOUGHTCRIME Ep. 99 — THOUGHTCRIME IRL
54.1K19 -
LIVE
Flyover Conservatives
9 hours agoSilver Shortage ALERT: London Vaults Running Dry in 4 Months- Dr. Kirk Elliott; 3 Tips to Transform Your Business - Clay Clark | FOC Show
330 watching -
1:10:18
Glenn Greenwald
4 hours agoIsrael Pays Influencers $7,000 Per Post in Desperate Propaganda Push: With Journalist Nick Cleveland-Stout; How to "Drink Your Way Sober" With Author Katie Herzog | SYSTEM UPDATE #525
71.2K65 -
38:54
Donald Trump Jr.
8 hours agoDems' Meme Meltdown, Plus why California Fire Victims should be more Outraged than Ever | TRIGGERED Ep.279
95.2K80 -
LIVE
megimu32
1 hour agoOn The Subject: Meg’s Birthday Bash! 🎂🎶
139 watching -
23:47
Jasmin Laine
6 hours agoALL HELL BREAKS LOOSE—Eby MELTS DOWN While Poilievre CORNERS Carney
5.01K11 -
LIVE
SpartakusLIVE
3 hours agoNEW Black Ops 7 BETA || WZ too! And PUBG later?
193 watching -
1:00:02
BonginoReport
5 hours agoTerror Strikes Manchester Again - Nightly Scroll w/ Hayley Caronia (Ep.147)
75.3K52