EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL

G

Guest

I have a significant amount of data that I have subtotaled in excell. I
would like to copy (and use) the subtotals only in another excell
spreadsheet...but when I try to copy and paste I continue to get the detail.
How can I copy just "what I see" on the subtotals worksheet ?
 
D

Debra Dalgleish

Select all the cells that you want to copy
Choose Edit>Go to, and click the Special button
Select Visible Cells Only, and click OK

Choose Edit>Copy, then paste the cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying only subtotals 1
subtotal 1
subtotals copying 3
how can I print and sort JUST the subtotal lines, not the detail 1
Copying Cells in List 2
Copy subtotals 1
Presenting Subtotals only 2
Sorting Subtotals 11

Top