Excel has hundreds of features, and I still discover new ones every year. Some solve very specific problems, while others become so useful that they quietly earn a place in every workbook I create.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn’t. Using an old function and a matrix tames the problem. The article How to easily ...

This article provides step-by-step instructions for color customizing your drop-down list in Microsoft Excel. Color can be a powerful element in an Excel drop-down list, and it’s easier to add than ...