How to Sort Pivot Table

In most situations, Pivot Table can be sorted in the same way as other regular data tables (see how to make a simple Pivot Table):

Step 1: Move your mouse to the column which you want to sort and right click;

Step 2: Click "Sort" from the dialog box;

Step 3: Select "Sort Smallest to Largest" or "Sort Largest to Smallest" when working with numeric data;

- Select "Sort A to Z" or "Sort Z to A" when working with text data;

- Select "Sort Newest to Oldest" or "Sort Oldest Newest to Newest" when working with the date and time.

Leave a Reply