Excel Data Validation is a feature that restricts (validates) user input to a worksheet. Technically, you create a validation rule that controls what kind of data can be entered into a certain cell.
This Video also explains how to create data validation list dynamically.
Email: [email protected]
Channel: / @samsgridview9652
Templates:
Inventory Management: • Invoice | Stock | Billing Tool | Inventory...
Covid Dashboard Playlist • Covid Dashboard
Quick Bites:
Flash Fill • Flash Fill in Excel - Quick and Effective ...
Quick Analysis • What is Quick Analysis in excel..? Ctrl+Q
3 Steps to clear Formats • Fast 3 ways to clear your existing cells f...
Shortcut Challenge • Shortcut Challenge in excel | Fromat your ...
Dynamic Vlookup • Dynamic Vlookup vs Regular Vlookup | Excel...
Autosum and Subtotal: • Autosum vs Autofilter..? | Excel | Sam's G...