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.

Make sure the box next to "In-cell Drop-down" is checked. Click inside the "Source" field, and then switch to the worksheet containing the list values. Select the range of cells containing the values.