Category Archives: Sort and Filter

New Pivot Items at End of List

Why do new pivot items appear at the end of the lists, when you add them to an Excel pivot table? It’s hard to find those new items, if they aren’t sorted alphabetically. Keep reading, to see why that happens, … Continue reading

Posted in Sort and Filter | 1 Comment

Pivot Table Top 10 Filter From Worksheet Values

Top 10 Filters are a quick and easy way to focus on key items in a pivot table. Instead of looking at all the data, hide everything except a set number of top or bottom items. In the screen shot … Continue reading

Posted in Sort and Filter | 4 Comments

Hide Arrows in Pivot Table Headings

After you set up a pivot table, you might like to prevent people from selecting items in one or more of the heading drop downs.

Posted in Sort and Filter | Leave a comment

Sort Items in Excel Pivot Table Report Filter

When you add new items to a pivot table, they might not appear in alphabetical order in the Report Filter drop down. This can make the items hard to find, if there is a long list. In the drop down … Continue reading

Posted in Sort and Filter | 8 Comments

Sort Pivot Table Left to Right

When you create a pivot table, the items in each field are sorted alphabetically, in ascending order, like the products and cities shown below. The only exception to this is for items that appear in a Custom List, such as … Continue reading

Posted in Sort and Filter | 1 Comment

Apply Multiple Filters on a Pivot Field

Instead of looking at all the data in a pivot table, you can use filters to narrow your focus. The most noticeable ones are the Report Filters at the top of the pivot table. You can use those to select … Continue reading

Posted in Sort and Filter | 2 Comments

Dynamic Date Range Filters in Pivot Table

In the source data for your pivot table, you can use the drop down filters in the heading cells, to show only the records for a specific date range. For example, in the table shown below, you could show just … Continue reading

Posted in Sort and Filter | Leave a comment

Show New Pivot Table Items in Alphabetical Order

When you add new items to a pivot table, they might not appear in alphabetical order. In the screen shot below, Binders is a new item, and it’s at the end of the list, instead of at the top. Another … Continue reading

Posted in Sort and Filter | 1 Comment

Quickly Clear Filters in Excel

If you frequently use filters in your pivot tables, here is a quick way to clear them. Thanks to AlexJ, who shared this tip. You can find more of AlexJ’s Excel sample files on my Contextures site. If you use … Continue reading

Posted in Sort and Filter | Leave a comment

Show and Hide Pivot Table Details

In a pivot table, you can show all the summarized data, or focus on specific details. One way to hide information is with filtering, and that affects the pivot table totals. In the screen shot below, the Category field has … Continue reading

Posted in Sort and Filter | Leave a comment