+ Reply to Thread
Results 1 to 6 of 6

Manually Sorting Pivot Table Row Labels

  1. #1
    Registered User
    Join Date
    09-16-2009
    Location
    Fairfax, VA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Red face Manually Sorting Pivot Table Row Labels

    Hi all!

    I am working with a PivotTable (and I'm new to them, so be gentle!) and I need to sort the table by row label manually. I have highlighted the following excerpt from the applicable Excel Help file.

    Sort data in labels
    ...
    Optionally, to customize the sort operation, on the Options tab, in the Sort group, click Sort.
    In the Sort <Field name> dialog box, select the type of sort that you want by doing one of the following:

    To return items to their original order, click Data source order. This option is only available for OLAP source data.
    To drag and arrange items the way that you want, click Manual.
    To select a field to sort by in ascending sort order, select Ascending (A to Z) by, and then select the field from the drop-down list.
    To select a field to sort by in descending sort order, select Descending (A to Z) by, and then select the field from the drop-down list.
    Tip Read the Summary section at the bottom of the dialog box to verify your choices.

    My problem is this: after following the above steps, then clicking Manual, then ok, I cannot drag and arrange the row labels in the PivotTable. I'm sure there is a simple solution to this problem, but if someone could walk me through it, I would greatly appreciate it!
    Last edited by brandonkmoon; 09-18-2009 at 02:29 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Manually Sorting Pivot Table Row Labels

    If you click on a given label and then "hover" towards the bottom right corner of said label you should find the cursor changes to a four way arrow at that point left click and then drag to wherever you want that label to be positioned.

  3. #3
    Registered User
    Join Date
    09-16-2009
    Location
    Fairfax, VA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Manually Sorting Pivot Table Row Labels

    Bless you!

    I love this forum. It is now 2 for 2.

  4. #4
    Forum Contributor
    Join Date
    07-22-2008
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2007
    Posts
    130

    Re: Manually Sorting Pivot Table Row Labels

    Ok that's fine. But do I have to sort it manually every time? Isn't there any way to save this order so that I can apply next? I don't mind doing manually at first time, but it would be nice if I save it as custom sort.

  5. #5
    Registered User
    Join Date
    08-06-2014
    Location
    Dallas, TX
    MS-Off Ver
    2010
    Posts
    1

    Re: Manually Sorting Pivot Table Row Labels

    Grabbing the corner of the cell did not work for me, BUT here is what did work for me:
    - Right click in one of the cells and you should see a choice for "Move"
    - You can move up or down, beginning or end. And when you do this the entire grouping that this cell represents will move too. So easy now that I know!

  6. #6
    Registered User
    Join Date
    08-15-2014
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    1

    Re: Manually Sorting Pivot Table Row Labels

    Thank you so much for the help sorting Column Labels....great help, saved me alot of time

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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