My IT Diary

To make a Drop Down List in a Excel cell,

1. Select the cell
2. Data Menu
3. Click Validation
4. For the drop down list Allow, choose LIST
5. In the text box Source add items separated by comma.
6. Click OK