Create a Drop Down Menu in Excel
Want to create a drop down menu in Excel?
Here's a quick walk-through on how to do just that.
Select the cell you want the dropdown to be in, then go to the Data tab, Data Tools section and click Data Validation.
From here, under Allow you'll choose List and then either enter the options you want to allow, or select the range of cells that contain your list options and hit OK.
It's that simple!
Follow for Excel tips, tricks and more!
🌍 Want to get moving faster in Excel? Take my 7 Days to Excel Challenge and level up today:
https://www.tmbanalytics.com/excel-fo...
📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:
https://www.tmbanalytics.com/excel-fo...
👉 Connect with me on social! Linkedin: / mattbrattin Tiktok: / mattbrattin
#excel #shorts