View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default 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