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 …

When creating a Microsoft list, you can save time by importing an existing Excel spreadsheet. This method converts the table headings to columns in the list, and the rest of the data is imported as list …

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.

When creating a Microsoft list, you can save time by importing an existing Excel spreadsheet. This method converts the table headings to columns in the list, and the rest of the data is imported as list …

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.

Track information and organize work with Microsoft Lists. Create a list from scratch, from Excel , from an existing list, or from a template. Watch this video to learn how.

But, you can also double-click a cell and paste the whole list into the cell. If you're using text in a shape or text box, apply bullets and numbering by right-clicking the text, then select the Bullets option.

In SharePoint or the Microsoft Lists app, export list items shown in the current view to Excel so that you can work with the data in a workbook.