Column Drop Down Excel. 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. An excel drop down list or dropdown menu can make it easier for the average microsoft excel user to enter data on a worksheet or workbook.
However do not include the header cell. Using a drop down menu in web forms surveys or polls can. You can add drop down lists to cells in excel containing options such as yes and no male and female or any other custom list of options.
How to add a drop down list to a spreadsheet column in excel.
On the settings tab in the allow box click list. 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. A wizard box appears. On the settings tab in the allow box click list.
