Copying subtotals Only

  • Thread starter Thread starter mods1
  • Start date Start date
M

mods1

Hi I have a huge tax spreadsheet I subtotal by county, the only problem is
when I try to copy only the visible cells, I get everything... Short of
deleting all the lines in between is there an easiser way??
Thanks,
 
Try this method:
Set only subtotal rows visible!
Edit>Goto>Advanced>Current Area
Edit>Goto>Advanced>Visible cells only
Copy and Paste!

Regards,
Stefi

„mods1†ezt írta:
 
Hi,
Highlight the cells to be copy, press F5, Special, visible cells only, copy,
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

Copying only subtotals 1
Extremely sloooooooooow subtotalling 3
subtotal copy and paste 3
Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
subtotal titles 1
Sorting Subtotals 11
Copy within a subtotal 1

Back
Top