Drop Down Lists with Data Validation in Excel

Описание: Time Stamps:
1. How to create (Auto-update drop-down list) dynamic smart drop-down lists that grow as new categories are added: 02:23
2. How to restrict cell input to values that have a specific length (or are greater or less than set total characters): 11:50
3. How to restrict numbers input to fall between predefined values: 13:36
4. Custom error alert message creation: 15:18
5. How to restrict cell input to dates that fall between two values or dates that are in this: year i.e. 2020: 17:32
6. How to copy and paste data validation to other cells: 18:38

"This video is about how to Create SMART Drop Down Lists with Data Validation in Excel and Everyone must know it.

In this video, you can learn how to create a drop-down list in Excel or add other data validation checks custom messages, custom error alerts. By the end of this tutorial you will learn:

1. How to create (Auto-update drop-down list) dynamic smart drop-down lists that grow as new categories are added
2. How to restrict cell input to values that have a specific length (or are greater or less than set total characters)
3. How to restrict numbers input to fall between predefined values
4. Custom error alert message creation
5. How to restrict cell input to dates that fall between two values or dates that are in this: year i.e. 2020
6. How to copy and paste data validation to other cells

I have explained it in an easy way so that everyone can understand and apply these to their work professionally. If you do not know Data Validation or Drop-down list then you must watch the complete video.

In this video, you will know how to create Dynamic Drop Down List in Excel 2016. In this Drop Down List Tutorial, you will know how to use data validation in Excel and custom data validation in excel. Data Validation in Excel Bangla makes you the Data Validation in Bengali to learn better. Drop Down list in excel in Bengali make you better in your mother tongue.

I hope you will like the video. Thanks for watching it.
XL ONE | Pratap Swarnakar"


আশা করি ভিডিও টি তোমাদের ভাল লেগেছে। ভিডিও টি দেখার জন্য অসংখ্য ধন্যবাদ।

XL one এর ভিডিও গুলো ভাল লাগলে চ্যানেল এর ভিডিও গুলো Facebook আর Whatsapp এ শেয়ার করে অন্যদেরও দেখার সুযোগ করে দেবেন | আশা করি আগামী দিনেও এই ভাবে XL one চ্যানেলটির সাথেই থাকবেন|