To create a drop-down menu in Excel, you will need to create a column with the items that you want to be in the drop-down menu. You would then select the cell where you want the drop-down menu to appear. you would then go to Data then Data Tools then Data Validation. In the Data Validation dialogue box, within the settings tab, select List as Validation Criteria.