Dropdown Menu Excel Maken. Filling in the drop down menu in excel head to your list worksheet and select all of the items that you d like included in your list. In the spreadsheet select the cell to contain the drop down list.
On the settings tab in the allow box click list. Separate each value you enter with a comma. Make sure to enter each drop down entry in a separate consecutive cell in the same column.
Note that if ever you choose to add or delete an item from your list excel will automatically update the data validation.
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. Note that if ever you choose to add or delete an item from your list excel will automatically update the data validation. Om een dropdown menu te maken in excel doorloop je de volgende stappen. 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.
