how to make a drop down menu in excel 2016

Like a multiple-selection list box, a list box displays all of the items in the list by default.ĭrop-down list box Like any other list, a drop-down list box offers users a list of choices. However, with a list box, users can select only one item in the list. List box Like a multiple-selection list box, a standard list box allows users to select values in a list. To decide which of these controls works best on your form template, refer to the following list: Microsoft Office InfoPath includes controls that are similar to multiple-selection list boxes but that serve different purposes. In the Multiple Selection List Box Properties dialog box, you can type the entries yourself or configure the multiple-selection list box to retrieve entries from a database or other data source. Otherwise, users will see an empty box when they open a form that is based on your form template. Consequently, users can enter a value in an empty box next to the last check box in the list.Īfter you insert a multiple-selection list box on your form template, you must specify the values that you want to appear in it. The form designer has chosen to permit custom categories. In the following illustration, users can assign expenses in an expense report form to multiple categories by selecting check boxes in a multiple-selection list box. Show most or all of the items in a list on the form by default.ĭisplay values retrieved from a fixed list, from the form template's data source, or from an external data source, such as a database or Microsoft Windows SharePoint Services list. Use a multiple-selection list box when you want to:Įnable users to select multiple items in a list.Įnable users to type their own value in a list. When to use a multiple-selection list box

Depending on how you design the multiple-selection list box, users may also be able to type their own list item next to one of the check boxes. Users can select as many check boxes as necessary from the list.

A multiple-selection list box is list of choices that looks like a scrollable list of check boxes instead of a typical list box.

How to make a drop down menu in excel 2016