How Do You Add A Drop Down Box In Excel 2007?
• Open the spreadsheet in which you want to add the drop-down box(es). • Create a list of the items to appear in the drop-down list. Type the data in the order it will be displayed in the list. The entries should be typed in a single column or row and should not contain any blank cells. • To create the list of the desired items on a separate worksheet, click the tab of the worksheet in which to enter the data. Type and then highlight the data to appear in the list. Right-click the highlighted range of cells and click “Name a Range” from the list that appears. Type the name for the range in the “Name” box and click “OK.” You can then protect or hide the worksheet to prevent other users from making changes to the list. • Click the cell you want to place the drop-down box in. • Click the “Data” tab of the Microsoft Excel 2007 ribbon. • Click the “Data Validation” button from the “Data Tools” group. The “Data Validation” dialog box appears. • Click the “Settings” tab and then click “List”
