Browse » Home
Monday, August 13, 2012
How to Insert the Same Drop
1. Enter the list items in a column on the spreadsheet where you will not need to enter other data, such as on the far right or bottom of the page. Enter the items in the order you want them to appear in the list, one item per cell. Make sure there are no blank cells between the items.
2. Select all of the cells into which you want to insert the drop-down list. If the cells are contiguous in one row or column, you can select them by clicking the first cell and dragging your mouse down or across the row or column. If they are in noncontiguous cells, press and hold the 'Ctrl' key while you click on each cell into which you want to insert the drop-down list.
3. Go to the 'Data' menu in Excel 2003 and select 'Validation.' In Excel 2007 or 2010, go to the 'Data' tab, click the 'Data Validation' button. The 'Data Validation' dialog box will open.
4. Make sure you are on the 'Settings' tab. Select 'List' in the 'Allow' box. Click inside the 'Source' box and then select the range of cells containing the list you created in the first step.
5. Make sure 'In-cell Dropdown' is checked. Clear the 'Ignore Blank' check box if you want to require users to enter data into the cell. Click 'OK' to insert the drop-down list into all of the selected cells.