Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Although the gadget does not include an option for configuring the display of categories in a drop-down menu, you can achieve this effect by editing the HTML of your blog design.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.