🔥 How to create a drop-down list in Excel in seconds!

wouldn't it be cool to add a drop- down list to your Excel report well here's how you can do it in Microsoft 365 I want to add a drop- down so you can select your favorite snack the list of snack options is on another sheet right here what I'm going to do is Right Mouse click go to search the menus and start typing in validation and select validation for allow select list Source go and select the list of options and include empty cells if you want to expand this list then click on okay and we get our drop- down immediate here with two really cool features number one is that duplicates are automatically removed there was a duplicate here I wonder if you can spot it in addition to the empty cells which we also see just one of them in the drop down plus we get the ability to search for stuff so if I start typing in peanut I can see the different options here so my favorite snack is peanut butter toast and my second favorite snack I'm just going to copy and paste this is chips and yogurt what are your favorite snacks

Channel: Leila Gharani

Views: 33,937

Keywords: XelplusVis, Leila Gharani, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, Microsoft Excel tutorials, Microsoft Excel, Excel 2016, Excel 2013, Excel 2019, XelPlus, Microsoft 365, Excel 365, drop-down list, excel selection list, excel list, excel select from drop-down, searchable list, how to, search within drop down list, dropdown in excel, data validation

Id: QWL15bYXwvs

Length: 1min 0sec (60 seconds)

Published: Sun Jan 07 2024