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
Mostly Sports With Mark Titus and Brandon Walker
16 hours agoMostly Sports with Mark Titus & Brandon Walker Presented by Jägermeister | EP 195 | 6.24.24
288 watching -
1:15:39
Graham Allen
3 hours agoWW3 Already Start?! Russia Blames BIDEN For Attack! + AOC Embarrasses Herself In The Bronx
17.9K78 -
2:04:42
Matt Kohrs
11 hours agoStocks On Edge, Crypto Plummets & Live Trading $1M || The MK Show
16.6K1 -
1:55:31
jeffahern
2 hours agoMonday Madness with Jeff Ahern
5.36K4 -
11:45
Bearing
2 hours agoJust Stop Oil - Climate Crusaders or Eco Patsies?
7.19K14 -
11:04
Misha Petrov
19 hours agoSelf-Love or Narcissism? The Impact of Self-Help Influencers
18.2K66 -
19:01
DepressedGinger
1 day ago $0.01 earned*CRAZY* Biden-Trump NUCLEAR debate could change the Election?
37.8K70 -
26:38
Destene and Brandon
21 hours agoBrunch to celebrate the new baby! | Putting together care packages | Game Night | Pool Update &MORE
26.8K3 -
9:37
scoutthedoggie
1 day agoAirsoft Sniper on Your 12
36.9K1 -
10:56
ryanhoguepassiveincome
16 hours agoTOP 5 NICHES 🔥 Print on Demand Niche Research # 213 — (6/23/2024)
35.5K2