Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Excel Tables offer a range of features for working with list-style data.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

Formatting data in an Excel table is crucial for enabling dynamic updates and maintaining up-to-date drop-down lists.

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

How to Create a Table That Makes Choices in Excel 2007. Excel enables you to include data validation for a cell, limiting the type and content of any inputted data. In addition, you can limit data ...

How to create an automated list of worksheet names in Excel -- and add a table of contents.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Clicking and dragging the fill handle in Microsoft Excel to create a numbered list is unreliable, non-dynamic, and time-consuming, especially if the list is lengthy. Instead, you can combine two ...