Subtotals copy paste

G

Guest

Hello,
I would apprecaite providing me a solution to copy and paste the Subtotals
in Excel. Generally if we copy and paste subtotals it will come with all the
details of the Subtotals. I don't want details I need only the Subtotal to
come when I paste. Please help me to solve this issue or advise me any other
fuction/operation with which I can get the subtotals only.

Thanks
 
G

Guest

Assuming the table is collapsed to suit
Select the range
Press F5 > Special > Visible cells only > OK
Right-click on the selection > Copy
Then just go to the new sheet > paste
 

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

Presentation 1
Copying Subtotals to new worksheet 2
Subtotals & Conditional Formatting Part 2 1
paste only subtotals, not individual date that makes up subtotal 4
Original subtotals should not be within nested subtotals in excel 1
Subtotals 1
Subtotals 1
How do I copy, paste subtotals only from an Excel list? 2

Top