How do I change order of rows in pivot table?

G

Guest

The excel pivot table tutorial shows regions as rows in alphabetical order.
I understand I can use the sort command to reverse that order, but how do I
specify the order of the regions as north, south, east, west? Thanks.
- greg
 
G

Guest

click on south, hold the left key on the mouse and drag South below North and
release the key. Now South should be below north. hope this helps.

Nikki
 
G

Guest

Oh. That was too easy, huh? Thanks!
--
- greg


Nikki said:
click on south, hold the left key on the mouse and drag South below North and
release the key. Now South should be below north. hope this helps.

Nikki
Click to expand...
 

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

Can I choose more than one item in the page field area? 1
Preferred way to do sort order - column in table, or specified in query? 3
Pivot table 5
Pivot Table Sort Order 1
How can I allow only one record per category? 3
Weighted Average in Pivot Table 5
Pivot table grand total options 3
Surpressing rows and columns with zero values in a pivot table 1

Top