Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Microsoft Excel's list function allows you to display several different values in a single cell using the form of a drop-down menu.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.