What If EXCEL Data Validation Is MORE Than Just A Dropdown List?

Are you tired of thinking that Excel data validation is only good for creating dropdown lists? Think again! In this video, we'll explore the untapped potential of Excel data validation and show you how to unlock its full capabilities. From restricting user input to creating custom error messages, we'll dive into the advanced features of data validation that will take your Excel skills to the next level. Whether you're a beginner or an experienced user, you'll learn how to leverage data validation to create more efficient, accurate, and user-friendly spreadsheets. So, what are you waiting for? Let's dive in and discover the power of Excel data validation beyond the dropdown list! #excel #exceltips #howto #pmo #fyp #datavalidation #microsoftexcel Link to support file which you can download for free to follow along: https://drive.google.com/drive/folders/1QhvJT3tcowaXpf5iyytywn3syPC_P-XB?usp=sharing Delivered by @Changetipsandtools This video contains: 00:00 - Intro 00:46 - The Dropdown list 02:43 - Dependent dropdowns - the filter and # trick 05:24 - Validation on Numbers 06:57 - Validation of Dates 07:45 - Time validation 08:55 - Text Length validation 10:46 - Custom validation (unique values) 13:43 - Using custom validation with multiple criteria 15:51 - Ways to stop user overwriting your data validation (Time for some simple visual basic) 16:28 - How to save Excel file as a macro enabled file 16:53 - Disable cut paste with Visual Basic 20:21 - Set CRTL + V as paste values only with Visual Basic