Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection ...

If it doesn’t pop up, right-click the pivot table and ... 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.

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