In this excel tutorial, we are going to see how to add dropdown list in Excel 2016 and 2013. Excel users can add drop down using the option available as part of Data Validation settings.
Adding dropdown in Microsoft Excel
Step 1: Click Data in Office Ribbon and navigate to Data Tools section.
Step 2: Click the arrow pointing downwards below Data Validation and select Data Validation from the dropdown list.
Step 3: Click the Settings tab under Data Validation window and select List for the Allow dropdown list.
Step 4: Now enter the Data that needs to be displayed in the Source column i.e 2013, 2012, 2010, 2009, 2008,2007,2006. You can also provide a cell range with the defined set of values.
After entering the required data, click OK button to confirm and save the changes. Now selecting the cell and then clicking dropdown arrow should display the dropdown list.