Results 1 to 3 of 3
  1. #1
    lparkhill
    Guest

    Copy subtotal values question (Excel 97)

    I have subtotals of several different rows. I need to copy just the totals to another worksheet, how can I copy just the subtotals without getting all the data used to get the subtotals?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy subtotal values question (Excel 97)

    Just hold down the Ctrl key and click on each of the cells. Then Copy the cells and past them into the other sheet.
    Legare Coleman

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copy subtotal values question (Excel 97)

    I pesume you have a list with subtotals by use of the Data, Subtotals command. If so, hide all th e detail, select the remaining rows (the sub totals), the press F5 (Goto), click Special, then select Visible Cells Only. Then copy and when you paste you should just have the subtotals.

    Andrew C

Posting Permissions

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