How do I change order of rows in pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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

Preferred way to do sort order - column in table, or specified in query? 3
Can I choose more than one item in the page field area? 1
Pivot Table Sort Order 1
Count Numbers 12
Weighted Average in Pivot Table 5
Need help with complex pivot... 4
PIVOT - refresh pivot based on Field / item 1
conditional formatting in pivot table 1

Back
Top