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
-
48:05
Dave Portnoy
1 hour agoThe Unnamed Show With Dave Portnoy, Kirk Minihane, Ryan Whitney - Ep. 19
10.7K1 -
DVR
Benny Johnson
1 hour agoTop Democrats PANIC as New Polls Show DOOM For Biden | Trump SURGES 📈 | 'Time To Replace Joe?'
26.9K24 -
57:58
The Rubin Report
2 hours agoDebate over COVID Failures Gets Tense | Chris Cuomo
27.5K24 -
2:06:37
Steven Crowder
3 hours agoREBUTTAL: Jon Stewart is WRONG about Gun Violence
120K194 -
2:10:55
Matt Kohrs
3 hours agoStocks Are EXPLODING HIGHER, Nvidia is King & GameStop is Falling
29K6 -
1:28:50
Graham Allen
4 hours agoMega Church Pastor Forced to RESIGN! + Ten Commandments Back in Schools🔥
32.4K94 -
44:57
Rethinking the Dollar
2 hours agoGOP WANTS $500 BILL TO HONOR TRUMP | SIGNS OF GREATER INFLATION TO COME? | Morning Check-In w/ Mike
17.9K4 -
1:36:11
The Podcast of the Lotus Eaters
7 hours agoThe Podcast of the Lotus Eaters #941
42.1K33 -
1:17:47
jeffahern
4 hours agoThursday Thrash With Jeff Ahern (6am Pacific)
23K3 -
2:05:19
AP4Liberty
4 hours agoBorder Wars Breakout Between Kansas and Missouri... Again!
26.4K3