SMART Drop Down Lists in Excel (with Data Validation)

preview_player
Показать описание
Learn how to create a drop-down list in Excel quickly, as well as how to add various data validation checks. You will learn the following by the end of this tutorial:
1. How to make dynamic drop-down menus that expand when additional categories are introduced
2. How can I limit cell input to dates that are either between two values or larger than today's date?
3. How do I limit cell input to values of a certain length? (or are greater or less than set total characters)
4. How to limit the range of numbers that can be entered to a set of specified values
5. How to paste data validation into other cells by copying and pasting.

DOWNLOAD the workbook here:

Let’s connect on social:
Рекомендации по теме
Комментарии
Автор

Thank you! Thorough explanation and very helpful. 👏

ThinkFutureAcademy
Автор

Today I learned the unique technique of creating drop down list, thanks for sharing such a nice video

thevisainfo
Автор

Very informative content and I especially like the way you deliver it! Thank you

RED-EDUCATION
Автор

Your videos are interesting, thank you for always adding something new in our Excel knowledge! 👌🏽👏

azizinamch