Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Pivot table ordering

basic excel training - Pivot table ordering

ResolvedVersion Standard

Wed 19 Sep 2007, 14:44 Delegate Liz said...

Liz has attended:
Excel Advanced course

Pivot table ordering

Is there anyway to order pivot table headings alphabetically? I understand that you can do bring to beginning etc, but this maybe quicker.
Or a way to do it desending / ascending based on a particular column or row?

Regards,
Liz

Mon 1 Oct 2007, 15:41 Trainer Amanda said...

RE: Pivot table ordering

Hi Liz

Thank you for your question.

Try the following:

1. Double-click on the field you wish to sort by.
2. Click the Advanced button.
3. You will find AutoSort options on the left of the dialogue box that you can use. Select the field you wish to sort by (if possible) and click OK.

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

basic excel training - Pivot table ordering

Pivot table ordering

RE: Pivot table ordering

Excel articles

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010