EXCEL Techniques

1. Create the list in cells A1:A4. Similarly, you can enter the items in a single row, such as A1:D1.
2. Select cell E3. (You can position the drop-down list in most any cell or even multiple cells.)
3. Choose Validation from the Data menu.
4. Choose List from the Allow option's drop-down list. (See, they're everywhere.)
5. Click the Source control and drag to highlight the cells A1:A4. Alternately, simply enter the reference (=$A$1:$A$4).
6. Make sure the In-Cell Dropdown option is checked. If you uncheck this option, Excel still forces users to enter only list values (A1:A4), but it won't present a drop-down list.
7. Click OK.

How to copy lists from one cell to another

1. Select a cell that contains the drop down list you want to copy.
2. Copy the cell by pressing Ctrl + C or Right-click -> Copy.
3. Select the cells where you want to paste the drop down list.
4. Right-click, select paste special, click on Validation and press OK.