Microsoft Excel has a great sorting feature that works quite well. However, you can use this feature to sort cells based on their color. Multiple colors are supported, and from our testing, we can ...

Have you ever stared at a colorful Excel spreadsheet, wondering how to quickly calculate totals or counts based on cell colors? It’s a common frustration for anyone managing large datasets. While ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature. The article, How to use a border to discern groups more ...