+ Reply to Thread
Results 1 to 3 of 3

How do I change order of rows in pivot table?

  1. #1
    greghenry
    Guest

    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

  2. #2
    Nikki
    Guest

    RE: 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


  3. #3
    greghenry
    Guest

    RE: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1