Search in a PivotTable field list in Excel 2016 for Windows

You can quickly find the fields you are looking for in long lists of fields without scrolling, using the new search in PivotTable functionality. 

1. Click on the PivotTable with the fields you want to search for.

2. In the PivotTable Fields pane, enter the field name to find.

   

   The field you're searching for will now display at the top of the list.

   

See Also

Create a PivotTable to analyze worksheet data

Sort data in a PivotTable

Filter data in a PivotTable