How to create a drop down list in Excel? I will help you build dropdown lists all the way from the ground up. You can open your own Excel workbook, and follow along step-by-step if you like.

We are going to build a basic dropdown list, and a more advanced dropdown list dependent on another cell, and on top of that we will build a yes or no drop down list. #dropdownlist is a great functionality!

⏱️TIMESTAMPS⏱️
0:00 Introduction to Excel drop down lists
1:00 Purpose of using drop down lists
1:12 How to create a drop down list in Excel
2:12 Adding error alerts to drop down lists
3:40 Dropdown list dependent on another cell
6:07 Add new item in drop down list
7:18 Drop down list yes or no
8:34 Copy drop down list
9:07 How to hide drop down list data

Philip de Vroe (The Finance Storyteller) aims to make accounting, finance and investing enjoyable and easier to understand. And get some #excel skills along the way! Learn the business and accounting vocabulary to join the conversation with your CEO at your company. Understand how financial statements work in order to make better investing decisions. Philip delivers #financetraining in various formats: YouTube videos, classroom sessions, webinars, and business simulations. Connect with me through Linked In!

Want to get access to bonus content, and/or express your gratitude by buying me a cup of tea? Join my channel as a member through https://www.youtube.com/channel/UCQQJnyU8fALcOqqpyyIN4sg/join