To make data entry easier, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere in the workbook. When you create a drop-down list for a cell, it displays an arrow in that cell.

1. Type the list entries in a single column or row without blank cells. For example:

2. Select the cell where you want the drop-down list.

3. On the Data tab, in the Data Tools group, click Data Validation.

4. In the Data Validation dialog box, click the Settings tab.

5. In the Allow box, click List.

6. Click anywhere in the Source box.

7. Drag-select the cells you want to include in your drop-down list.

8. Click OK.

9. Click in the cell where you just created your list. Click the drop-down arrow to select a list entry.

 

 

 

 

This entry was posted on Sunday, May 2nd, 2010 at 9:38 pm and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.