# Sorting rows in the pivot table

To sort the pivot table by values of an aggregation:

1. Click the header of the aggregation in the pivot table

To sort within the first pivot column:

1. Check the box labeled Sort within first pivot column

To restore the original row order:

1. Click the header of any pivot column

See also:

- Adding a column to a pivot
- Creating an aggregation in the pivot table
- About the Pivot view

Back to Wizard Help