Conventional Sorting

You can sort the data in a pivot table using the conventional sort buttons on the standard toolbar.
This will be preserved when the pivot table is refresh

microsoft excel docsAscending - Sorts the data alphabetically from A to Z, 1 to 100, Jan to Dec and numerically from the lowest number to the highest.
microsoft excel docsDescending - Sorts the data alphabetically from Z to A, 100 to 1, Dec to Jan and numerically from the highest number to the lowest.

To sort a pivot table, select the field you want to sort and then select the appropriate button from the standard toolbar.
You some reason the black arrow to indicate that you can select a whole field is not always available - external database ??


The AutoSort feature provides a way of sorting the data based on the actual values or totals in the table.
This way the total with the highest number would always be displayed first.
This feature takes precedence over the conventional sorting, so using AutoSort will disable any conventional sorting.
This will be preserved when the pivot table is refresh

Using AutoSort

(PivotTable > Field Settings), Advanced Options.

microsoft excel docs

You can switch it off by selecting manual.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext