How to Create Excel Drop Down List
Learn how to create drop down lists in Excel in this step-by-step tutorial. By using drop-down lists, you can help people work more efficiently in worksheets by allowing people to pick an item from a list that you create.
In this video, I show you how to create a pre-defined drop-down list and a drop-down list based on another table. Additionally, I show you how to show an input message to provide users with a tool tip. Lastly, I also show how to display a warning message when users enter an incorrect value.
As full-disclosure, I work at Microsoft as a full-time employee.
Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Microsoft support article on creating drop down lists: https://support.office.com/en-us/article/Create-a-drop-down-list-7693307A-59EF-400A-B769-C5402DCE407B
Видео How to Create Excel Drop Down List канала Kevin Stratvert
In this video, I show you how to create a pre-defined drop-down list and a drop-down list based on another table. Additionally, I show you how to show an input message to provide users with a tool tip. Lastly, I also show how to display a warning message when users enter an incorrect value.
As full-disclosure, I work at Microsoft as a full-time employee.
Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
Microsoft support article on creating drop down lists: https://support.office.com/en-us/article/Create-a-drop-down-list-7693307A-59EF-400A-B769-C5402DCE407B
Видео How to Create Excel Drop Down List канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to Create Dependent Drop-Down List in ExcelUsing Checkboxes in Excel - Part 1Top 50 Microsoft Excel Shortcut KeysPivot Table Excel TutorialCreate SMART Drop Down Lists in Excel (with Data Validation)Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)Creating Easy Data Entry Forms in ExcelCreate Multiple Dependent Drop-Down Lists in Excel (on Every Row)How to Create a Drop-Down List in ExcelTop 20 Microsoft Excel Tips & TricksExcel Drop Down List Including Cell Colour Change: Colour FillHow to Create Macros in Excel TutorialHow to use Microsoft Power BI - Tutorial for Beginners🧙♂️ Pivot Table Excel Tips & TricksHow to Create Drop Down Lists in Cells - The Complete Excel GuideHow to use Excel Index Match (the right way)🔎 How to Create Searchable Drop Down List in ExcelAdvanced Excel - Data Validation and Drop-Down ListsHow to use COUNTIF and COUNTIFS in Microsoft ExcelHow to Filter in Microsoft Excel