If your Excel lists repeats values and you need help finding changes, try this easy conditional format. One of the most frequent requests I receive from readers is how to highlight list values when ...

Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area. They are also useful for limiting the choices an Excel spreadsheet user can make when editing ...

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. Filters are a ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...