Subtotals copy paste

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Additonal info into newly created Subtotal row 1
subtotal, match? 10
SubTotal 1
Subtotals 1
Subtotal of values in cells containing formula 1
Subtotal out of sequence 1
Subtotal 3
Presentation 1

Back
Top