How to Make DropDown List in Excel with Multiple Selections
Allow Multiple Selections In Excel Drop Down. On the data tab, in the data tools group, click data validation. Web to make a picklist from this table, the steps are:
How to Make DropDown List in Excel with Multiple Selections
On the form template, place the cursor where you want to insert the control. On the data tab, in the data tools group, click data validation. Web on the settings tab, in the allow box, select list. If the controls task pane is not visible, click more controls on the insert menu, or press alt+i, c. We put ours on a sheet called cities, in range a2:a9. On the data tab, on the data tools group, click the data validation button. Select one or more cells for your dropdown (d3:d7 in our case). Web to make a picklist from this table, the steps are: Select in the source box, then select your list range. Note that we left out the header row, because we don't want.
On the data tab, on the data tools group, click the data validation button. On the data tab, on the data tools group, click the data validation button. On the form template, place the cursor where you want to insert the control. Web on the settings tab, in the allow box, select list. We put ours on a sheet called cities, in range a2:a9. On the data tab, in the data tools group, click data validation. Web to make a picklist from this table, the steps are: Note that we left out the header row, because we don't want. Select in the source box, then select your list range. Select one or more cells for your dropdown (d3:d7 in our case). If the controls task pane is not visible, click more controls on the insert menu, or press alt+i, c.
