Drop Down Button In Excel. Select the cells you want the drop down list to appear in. You can find and double click a saved excel file on your computer or open microsoft excel and create a new worksheet step 2 enter the list of values for your drop down in a column.
If you already made a table with the drop down entries click in the source box and then click and drag the cells that contain those entries. On the settings tab in the allow box click list. Select the cells you want the drop down list to appear in.
The down arrow button only displays when the cell is selected.
Click the down arrow button to drop down the list of options and select one. Below is a step by step procedure to do this. To use the drop down box or combo box click any cell so that the object is not selected. When you click an item in the drop down box or combo box cell g1 is updated to a number that indicates the position in the list of the item selected.
