You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define. Skip to main content

Add or remove items from an existing drop-down list (also called a drop-down menu or drop-down box).

Under Insert controls, click Drop-Down List Box. If you cleared the Automatically create data source check box in step 3, select a field in the Drop-Down List Box Binding dialog box to which you want to bind the list box. To add a label to the control, type text above or to the left of the control, followed by a colon (:).

Create a drop-down list. Add or remove items from a drop-down list. Remove a drop-down list. Lock cells to protect them

To remove a drop-down list, click the cell with the list, then click Data > Data Validation, and then on the Settings tab, click Clear All, then OK. A drop-down list is also known as a drop-down box or drop-down menu.

You can populate a list box, drop-down list box, or combo box with data from a query data connection to a Microsoft SQL Server database. In this article. Overview. Before you begin. Step 1: Add a query data connection. Step 2: Configure the control. Overview

Wählen Sie auf der Registerkarte Einstellungen im Feld Zulassen die Option Liste aus.. Wählen Sie im Feld Quelle und dann Ihren Listenbereich aus. Hier wird dieser auf ein Blatt mit Orten und den Bereich A2:A9 festgelegt. Beachten Sie, dass die Überschriftenzeile ausgelassen wurde, da dies keine Auswahlmöglichkeit sein soll:

Like a multiple-selection list box, a list box displays all of the items in the list by default. Drop-down list box Like any other list, a drop-down list box offers users a list of choices. However, with drop-down list boxes, the list entries are hidden until the user clicks the control.

1. Click the arrow to display the drop-down list. 2. Click an option in the drop-down list. List boxes and combo boxes can be bound or unbound controls. These controls can look up values in a fixed list that you type yourself, or they can look up values in a table or query.

After inserting a drop-down list box, you must specify the choices that appear in the control, either manually or by retrieving them from a data connection. Use a drop-down list box when you want to: Enable users to make a single choice from a set of predefined options.