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.

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 …

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.

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.

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.

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

Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and …

Lists all Excel functions by their category, such as Logical functions or Text functions.

Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list.

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 …