When you want to filter all of the rows, the Select All option will apply the filter to your entire Excel table. Examples of filters for sorting text entries include Sort A to Z and Sort by Color.

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 ...

Learn how to create self-updating filters in Excel to simplify data management and save time with this step-by-step guide.

Excel spreadsheets can grow unwieldy as they get larger and larger in size. If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter ...

Hooking up slicers to one pivot table in Excel 2010 provides a programming-free way to create dashboards. One of the new features in Excel 2010 is a type of visual pivot table filter called a Slicer.