How do I change order of rows in pivot table? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              greghenry 3/27/2006 3:49 PM PST   Question   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     Was this post helpful to you?         Reply |   Top           Nikki 3/27/2006 6:36 PM PST   Answer   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     Was this post helpful to you?         Reply |   Top           greghenry 3/28/2006 6:40 AM PST   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     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies