Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

How to add a conditional format that highlights groups in Excel Your email has been sent The article, How to use a border to discern groups more easily in Microsoft Excel, shows you how to use a ...

How to quickly make Excel subtotals stand out from the data Your email has been sent Microsoft Excel’s Subtotal feature is a great tool, but you can make the ...

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...