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
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