Menu Dropdown Excel. Click in the source field then type the values you want to display in the drop down list. 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.
In the excel ribbon click the data tab. Now same as previously go to data tab data tools data validation. Make sure to enter each drop down entry in a separate consecutive cell in the same column.
On the data tab click the data validation option.
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. Click in the source field then type the values you want to display in the drop down list. Select list from the allow drop down menu. Using a drop down menu in web forms surveys or polls can.
