Drop-down lists in Excel
In this video tutorial, I'll show you how to create drop-down lists in Excel that allow you to select a piece of data from a set of possible options.
Download the template used in the video at the following link:
https://www.planillaexcel.com/blog/co...
In the first part of the video, we'll see how to create a simple drop-down list with a few options.
In the second part, we'll create a drop-down list based on a range of data from the same sheet where we want to create the list.
In the third part of the video, we'll see how to create a drop-down list using a range of data from a different sheet.
Finally, I'll explain how to make the drop-down list update automatically as new data is entered.
Chapters
00:00 Introduction
00:36 How to create a simple drop-down list
03:00 How to create a drop-down list based on a range from the same sheet
04:30 How to create drop-down lists based on a range from another sheet in the file
07:35 Auto-Updating Drop-Down Lists
If you want to learn how to create dependent drop-down lists, watch this tutorial: • Como armar listas desplegables dependiente...
=============================================================================
📚 Register for my FREE Excel Masterclass
https://www.planillaexcel.com/clase-e...
===================================================================================
🎓Do you want to master Excel? Learn step by step with my course
https://www.planillaexcel.com/cursos/...
==================================================================================
🔔 Subscribe and press the bell to find out about channel news
/ @planillaexcel
Find and download more free templates at: www.planillaexcel.com
👪 Follow us on our social networks:
►Facebook / planillaexcelcom
►Twitter / planillaexcel
► Instagram / planilla.excel