Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Summarizing the totals of a subtotal worksheet

    Good Morning,

    I performed a subtotal on a sorted worksheet. I would like to copy and paste as a value the results of the SUB-TOTALS ONLY on another worksheet so I can get % and perform sorts.

    Is this possible and if so, How is it done.

    Thank you.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Collapse the data so that only the subtotals you want are visible. Select those cells, then press Alt+; to select the visible cells only. Now copy and then Paste Special - Values.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I collapsed to the subtotal and highlighted the subototals I wanted and pressed "ALT with a +" and I heard a DING. I pressed control C and then on the new worksheet i pressed control V and nothing appeared. I am using EXCEL 2013 if that matters.

    Thanks

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi

    ..try ALT ; or, if you are using an Apple ⌘⇧Z

    ..these are the shortcut keys for selecting visible cells only in the selection range

    zeddy
    •Large Animal Accounting Crew
    .
    Last edited by zeddy; 2015-07-27 at 13:53.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts
    Hi

    You could try the F5 key.
    Select the option for visible cells.

    Make sure you have the data selected first though.

    Without knowing your exact intentions I would suggest that you read up on pivot tables.


    G
    Last edited by geofrichardson; 2015-07-28 at 02:35.

Posting Permissions

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