You can add a drop-down list in a cell using Excel Validation option. Adding a drop-down in a cell does not required any advance macro or coding kind of thing, the option is available within the menu options in Excel 2003, 2007, 2010 and 2013. Today we will learn creating a drop-down list in Excel and we would be using snapshot and menu options from Excel 2007
Step #1: First add a list of items in the sheet as following:
Step#2: We have added here four departments in B1, B2, B3 and B4. We will add these items into drop-down list items in cell A1 where we have initially put a simple text- Department. Now select the A1 cell.
Step#3: Click on Data Validation option in Data menu and select Data Validation option (First option).
Step#4: Data validation dialog box will be open where you need to select List as Allow and select the range B1 to B4 as Source, finally click OK.
Now you can see drop-down icon at right side of Cell A1 and the list of all items on clicking on that icon.
You can drag down or copy and past A1 cell value where you want use this drop-down list.