Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying from pivot tables (2003)

    How do you copy and paste numbers summarized from a pivot table to another area of the same spreadsheet as values?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying from pivot tables (2003)

    Welcome to Woody's Lounge!

    You should be able to copy some cells in the pivot table and paste them elsewhere. Do you experience problems with that? If so, please elaborate.

  3. #3
    New Lounger
    Join Date
    Jun 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying from pivot tables (2003)

    I figured out how to do it. I was trying to use the copy command from the mouse right click on the pivot table and you cant do that. You have to use the EDIT menu on the toolbar to copy the data. Thank you for responding HansV!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying from pivot tables (2003)

    You're welcome. Ctrl+C to copy the selected cells and Ctrl+V to paste them will work too.

Posting Permissions

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