Create Drop-Down Lists In Excel 2007

Similar to the functionality in Access, Excel lets you control entries by forcing users to select a value from a preconfigured list. By creating a drop-down arrow list, users must select from one of the possible preconfigured values. If someone tries to enter in something else, Excel rejects the entry.

You use the Data Validation feature in Excel to create a drop-down list. When you create a drop-down list for a cell, it displays an arrow within that cell.

Your first step in setting up a drop-down list in Excel 2007 is to create the preconfigured list of options. You can create the list in a single row or single column.

1. Open an Excel worksheet.
2. Click cell A1 and type in the first list value.
3. Continue to enter in each list option. For example, click cell A2, and enter in the second list option.

With the list options entered into the cells, you can create the drop-down list:

1. Select the cell that will contain the drop-down list.
2. On the Data tab, in the Data Tools group, click Data Validation.
3. From the Data Validation dialog box, click the Settings tab.
4. In the Allow box, select the List option.
5. Click the Source control and highlight the cells that contain the list options.
6. Verify that the In-Cell Dropdown option is selected. If this option is not selected, the drop-down list won’t appear, but users will still be forced to enter one of the list values.

Finally, click OK to close the Data Validation dialog box. The cell will now contain a drop-down arrow that when clicked, presents the list of preconfigured options.

• Microsoft Excel 2007
• Introduction to Microsoft Office Excel 2007 - Part 1
• Introduction to Microsoft Office Excel 2007 - Part 2
• Microsoft Word Home and Student 2007
• Microsoft Office Excel 2007 Version Upgrade
• Microsoft Office 2007 Basic FULL VERSION
• Microsoft Office Home and Student 2007
• Microsoft Office Standard 2007 FULL VERSION
• Microsoft Office Professional 2007 FULL VERSION
• Office 2007 All-in-One Desk Reference For Dummies (For Dummies (Computer/Tech))
• Excel 2007 Power Programming with VBA (Mr. Spreadsheet’s Bookshelf)
• Excel 2007 All-In-One Desk Reference For Dummies (For Dummies (Computer/Tech))
• Outlook 2007