Select the 5 rows then hit F5 and SpecialVisible cells onlyOK.

Copy and paste those.


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 13:44:00 -0700, "achidsey"
(notmorespam) wrote:


I have a spreadsheet where I can click on the "1" "2" "3" buttons to the
left to make different summary levels appear.

When I click on "2", I have just the five rows with subtotals visible.

I want to just cut and paste those just these rows rows to a different
spreadsheet, but when I paste, all the rows are pasted in, not just the
subtotals.

Is there a way to just paste the subtotals?

Thanks,
Alan