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.

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 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 with a list box to …

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.

You can create and share lists that help you track issues, assets, routines, contacts, inventory, and more. Start from a template, Excel file, or from scratch. If you're in Microsoft Teams, see Get started …

An array can be thought of as a row or column of values, or a combination of rows and columns of values. In the examples above, the arrays for our UNIQUE formulas are range D2:D11, and D2:D17 …

Download an example workbook with all data validation examples in this article If you're creating a sheet that requires users to enter data, you might want to restrict entry to a certain range of dates or …

This means that Excel will dynamically create the appropriate sized array range when you press ENTER. If your supporting data is in an Excel table, then the array will automatically resize as you …

You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.

From the Order drop-down, select Custom List. In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet. Create your own custom list Follow these steps to create …