Any of this help?
- Enter the items for your drop-down list into a list on the worksheet, one item per cell. In this example, I'll assume that the month names start in cell E1 and extend down to E12, but they can be in any out-of-the-way location on the worksheet. In Excel terminology, a rectangular group of cells (such as E1 to E12) is called a range.
- Select the cell that will contain the drop-down list. If you'd like more than one cell to display the same list, just select them all now rather than setting them up one at a time. (Click and drag to select a range; hold down Ctrl while you click to select non-adjacent cells.)
- Choose Data, Validation to display the Data Validation dialog box.
- Click the Settings tab.
- In the Allow field, select List.
- In the Source field, specify the range that contains the list items. In this example, the items are in cells E1 to E12, so type =E1:E12 into the field.
NOTE You cannot create a list in a shared workbook. You must remove the workbook from shared use first if you want to create a list.
A total row can be added to your list. When you click a cell within the total row, a drop-down list of aggregate functions becomes available.