Copy and Paste Subtotals only.

  • Thread starter Thread starter Jim15
  • Start date Start date
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
 
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
subtotal copy and paste 3
Paste Special Values 2
copy and paste if 1
Sorting Subtotals 11
Cut/Paste Subtotal Data 2
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL 1
Getting Text data using the Data - Subtotal feature 1

Back
Top