Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Apr 2001
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying subtotals

    Just wanted to say thanks to Ken for his tip on copying subtotals in Excel. I just discovered the joys of this particular function, but was not happy about having to select each row separately. This solves it. Since it is buried in another thread, here it is, and thanks again to Ken.

    "To copy just the subtotal rows only use the "group and outline" area to the left to hide the data and leave just the subtotal (and grand total) lines visible. Then select the subtotal cells you want to copy (probably all of them), then press Ctrl-G to bring up the GoTo Dialog, click on the special button, then choose "visible cells only" and press OK.

    Now click on the copy button or press Ctrl-C, and only the subtotals will be in the clipboard for you to paste where you want."

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying subtotals

    FWIW, you can use <Alt>; to shortcut the GoTo Special Visible Cells Only (that's the Alt key plus the semi-colon).

Posting Permissions

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