How do I copy an outline w/ subtotals & paste just the subtotals

G

Guest

I have a worksheet with data that has a group and outline in it. The group
and outline rolls up so that the groups contain subtotals. I want to copy
the subtotals from the group and outline and paste them into another
worksheet with just the subtotals (not with the rest of the rolled up data).
I cannot copy and paste just the subtotals, the data expands everytime I
paste it.
 
D

Dave Peterson

Use those outlining symbols to show just what you want to copy.

Then select that range
edit|goto|special
visible cells only

copy
and paste to the new location.
 

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
Paste Special Values 2
Using Subtotals in Other Sheets 7
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL 1
Copying subtotals 2
Subtotals 5
How do I copy a range in Excel without including hidden rows? 1
In Excel, how do you copy and paste just the subtotals into anoth. 4

Top