Results 1 to 3 of 3

Thread: How to move the total column in Microsoft Excel Pivot Table

  1. #1
    Join Date
    Jan 2012
    Posts
    27

    How to move the total column in Microsoft Excel Pivot Table

    I would like to have both the horizontal and vertical grand total columns in my pivot table to appear at the top line and left hand line respectively. At the moment they are at the bottom row of the table and the furthest column to the right, meaning I have to scroll to see either of them. I have only managed to move and sort the actual data columns around, but not these total columns.

  2. #2
    Join Date
    Nov 2010
    Posts
    422

    Re: How to move the total column in Microsoft Excel Pivot Table

    The position of the Grand Totals in a pivot table can't be changed. You can also manually put the columns in a desired order, but this is fiddly bit n drag drop: Click on the column heading you want to move, is moving with the mouse to the left or right edge of the mark (the "mark box") to the mouse pointer as a cursor (not the cross) displayed click and hold mouse button and release to move the column to the left or right and at the desired location.

  3. #3
    Join Date
    Nov 2010
    Posts
    503

    Re: How to move the total column in Microsoft Excel Pivot Table

    Simply click on the first column heading in the pivot table and then select "Sort Ascending" or "Sort Descending" from the Standard toolbar.

Similar Threads

  1. Replies: 2
    Last Post: 23-02-2012, 12:09 PM
  2. I need help to lock pivot table header in Microsoft Excel
    By cupid! in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 05:01 PM
  3. Replies: 2
    Last Post: 16-02-2012, 06:28 PM
  4. Replies: 5
    Last Post: 24-01-2012, 05:02 PM
  5. How to repeat row labels on Pivot Table in Microsoft Excel
    By Thedevotee in forum MS Office Support
    Replies: 2
    Last Post: 17-01-2012, 02:08 PM

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
  •  
Page generated in 1,713,880,499.19685 seconds with 17 queries