How do I make a dropdown list in an Excel sheet wherein the options come from a list of cells elsewhere.

1. Go to the "Data" tab.
2. Pick "Data Validation" therein.
3. Pick "Data Validation..." from the little menu that appears.
4. Pick "List" from "Allow:" at the little dialog box that shows up next.
5. At "Source:" you will denote the cells to use.