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,