How to Make Drop

1. Open Excel. Click on the Windows icon at the top of the the window and scroll down to 'Open.' Click on the command and browse through the folders on your computer to find your list. Click on it once to select it and click on 'Open.'
2. Click on a blank sheet in the workbook (use the tabs on the bottom to select a blank sheet). Type the entries you would like to see in your drop-down list in a column with no spaces in between the entries.
3. Highlight the list so it is all selected. Click in the name box (this is a text box next to the function bar) and give your list a name (for example, you can name it which column you will be using the list in).
4. Go back to your list and click in the first cell you want the drop-down list to occur. Click on the 'Data' menu at the top of the screen and click on 'Validation.' Click on the 'Settings' tab when the 'Validation' window opens.
5. Click on 'List' in the 'Allow' box. Type '=' and your list name in the 'Source' box. Click on the box next to 'In-Cell drop down.' Click on the 'Ignore Blank' box if the cell can be left blank. Once it is complete, click 'OK.'
6. Right-click the cell you have just created the list and click on 'Copy.' Highlight the entire column, right-click, and click 'Paste' to make every cell in that column into that drop-down list.