Excel: Dropdown list in cells

You can set up ca cell (or of course a range of cells) in excel so that when you click on the cell, it offers a dropdown list of items to select from.

The best way is as follows:

Create the list itself by typing into a range of cells, usually in a different sheet, then give […]