Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

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.

The second Excel drop down list will display the representatives in that region. To the right, you see labels and formats in preparation for creating the Excel drop down list. To create the Region ...

How to edit a drop-down list in Excel based on a cell range 1. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.