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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arrange columns (lo - hi) in a Pivot Chart bar graph. 2
Sorting Pivot Table by Total 1
order number in query 2
Excel How to preserve column fields in a specific order in a pivot table? 2
Pivot Table Chart Legend 2
Pivot Chart, changing the range of data weekly 1
auto filter data within pivot table 1
Manual sort in a pivot chart/pivot table 5

Back
Top