Copying subtotals Only
 

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,

Copying subtotals Only
 

Try this method:
Set only subtotal rows visible!
EditGotoAdvancedCurrent Area
EditGotoAdvancedVisible cells only
Copy and Paste!

Regards,
Stefi

€žmods1€� ezt Ã*rta:

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,

Copying subtotals Only
 

Hi,
Highlight the cells to be copy, press F5, Special, visible cells only, copy,
paste

"mods1" wrote:

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,