Dropdown Menu Excel Maken. Make sure to enter each drop down entry in a separate consecutive cell in the same 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.
Go to the data tab on the ribbon then click data validation. For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los. On the settings tab in the allow box click list.
In the settings tab select list from the arrow dropdown list.
Separate each value you enter with a comma. However do not include the header cell. Step 1 open the excel spreadsheet file you want to edit. 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.
