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.

If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add …

Add a list box to your Excel worksheet from which users can choose a value. Make data entry easier by letting users choose a value from a combo box. A combo box combines a text box …

Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.

Add a list box or combo box to an Excel worksheet. Each control lets user choose between a number of options.

If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add …

Microsoft Lists makes it simple to add, change, or delete items from a list. Try it! Select the list you want to edit. To add an item, select New. Add the details in each column for that item. Select …

To add a list of numbers, select the cell below a column of numbers, and then click AutoSum.

A multiple-selection list box is list of choices that looks like a scrollable list of check boxes instead of a typical list box. Users can select as many check boxes as necessary from the list. …

Create a list based on an Excel (.xlsx) file. There are different ways to start a list from an Excel file. You can go to the Lists app in Microsoft 365, SharePoint, or Teams.