Browse » Home
Sunday, May 27, 2012
How Do I Set a Dropdown List Box in Excel to Allow Multiple Selects?
1. Open the spreadsheet you want to create the drop-down list for in Excel.
2. Locate an area on the spreadsheet to house the list of data items that will appear in the drop-down list box. This can be in any location, or on a separate worksheet tab.
3. Type the list in several cells of a single column. Place each list item in the cell below the prior item.
4. Select the cells in your spreadsheet that will use the drop-down list box. Use the mouse and drag over the range of cells that are currently empty.
5. Click the 'Data' menu and select the 'Validation' command. A pop-up box will appear.
6. Choose the 'List' option from the 'Allow' menu on the 'Settings' tab.
7. Click in the 'Source' field. Select the cells you typed earlier that contain all the list items for the drop-down list box. Drag your mouse over these cells, and the cell address will be automatically entered into the 'Source' box. Click 'OK' when finished.
8. Click in any cell you chose for the list. An arrow appears on the right edge of the cell. Choose any of the multiple items in this drop-down list box for the value of this cell.