Copy and Paste Subtotals only.

J

Jim15

How do you copy and paste subtotals only? I use the Subtotal feature in
Excel to determine the maximum values for different entities in Excel.
I reduce the list to show the subtotals only and I want to copy and
paste these values in a separate spreadsheet. However, when I copy and
paste the maximum values, Excel pastes all of the data.

Thanks,

Jim
 
D

Dave Peterson

Use the outlining symbols to the left to show only the subtotals that you want.

Select the range to copy
edit|goto|special|Visible cells only
edit|copy

And paste to that new sheet.
 

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
copy and paste if 1
Copy and paste visible cells to outlook 1
Presenting Subtotals only 2
Using Subtotals in Other Sheets 7
Paste Subtotals Only 2
In Excel, how do you copy and paste just the subtotals into anoth. 4

Top