pivot tables

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I am trying to change the order in how the tables
display. I don't want an accending or decending alpha
order as it is set up now. I would like to pick and
choose how I want them listed.

How do I change the order?
 
You can select a row or column heading, and drag it to a new location in
the list.

If you try that, and see a message that "Autosort must be off" --

Double-click the field button for the item you're trying to move
Click the Advanced button
Under 'Autosort options', select Manual
Click OK, click OK
 
Back
Top