A drop down list is actually a tiny window from where you can peek into some other data you have constructed.
This also gives you the possibility of controlling exactly what can be entered into a cell. This makes the drop-down menu a very common and powerful data validation tool.
Luckily, creating a drop-down menu is super easy if you know the exact steps.
In a few seconds, I’m going to show you the exact steps to create your very own drop-down.
*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.
Follow along by downloading our sample file right below!