In the field list, drag Region from the top pane to the filters area (Figure F). Excel will add a filter above the pivot table.

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

You can delete a pivot table in Excel with a few clicks on a Mac or Windows PC. Here are two ways to do it.

Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again.