Working with the rows in a Pivot Table- dropdown

Please purchase the course before starting the lesson.

Once you have rows in a Pivot Table, you will notice that you have a variety of options available to you in the dropdown arrow.

This lesson covers how you can search for parts of a name, or search in the label or value filters, using the the Top 10 Option in the Value Filter to make sure that Pivot Table doesn’t overwrite another pivot table, sorting rows based on the words in the field itself (generally alphabetically), or one of the value fields.

To see the full course contents click here.

Back to: Intermediate Excel Course > Pivot Tables