Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Data validation is the foundation of creating drop-down lists in Excel. By setting up data validation rules, you can create lists that automatically update as your data changes.

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.

A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

How to Edit Lists on Microsoft Excel. Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area. They are also useful for limiting the choices an ...

In Excel 2007 you can start by entering a list of values in a contiguous range of cells. Click the Office button, choose Excel Options > Popular group and click the Edit Custom Lists button.

The Data Validation feature in Excel 2013 offers a List option to confine selections in a cell to a preconfigured series of values. This selection can further influence the values in another list ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.