Drop Down Button In Excel. 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. First with an excel sheet opened enter the values that you are planning to populate in your dropdown in a table.
Similarly you can enter the items in a single row such as a1 d1. To add the drop down list in our example to an excel sheet do the following. To use the drop down box or combo box click any cell so that the object is not selected.
How to make drop down choice buttons on an excel spreadsheet.
Go back to the table you want the drop down menu to be in. Now navigate to data data validation. Select the data validation button. Click the down arrow button to drop down the list of options and select one.
