cut and paste subtotal from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i cut and paste just the subtotal lines from an excel worksheet
without carrying all the data on the sheet?
 
Hide the details
select the range to copy
edit|goto|special|visible cells only
Copy and 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
Cut and Paste Subtotals 2
Cut and paste subtotals 2
Cut & Paste in Excel without erasing cell borders? 1
nesting sumproduct with subtotal 9
How do I copy subtotaled data without underlying details in Excel 1
subtotal, match? 10
Cut/Paste Subtotal Data 2

Back
Top