How do I change order of rows in pivot table?
 

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

How do I change order of rows in pivot table?
 

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

"greghenry" wrote:

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

How do I change order of rows in pivot table?
 

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


"Nikki" wrote:

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

"greghenry" wrote:

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