Creating Drop Down Boxes in Excel

Become a Master Craftsman

1. Select the range that is to contain the dropdown list box. This may be either a single cell or a larger range
2. Click Data, then Validation
3. Click the Settings tab (if necessary)
4. Under Allow, click the down arrow and select List
5. Using the Source box either enter the range or refer to a range