Hello:

I have an Excel displays subtotals based on the average of other fields.

I click the "2", in order to collapse the rows to just show the "Average"
and not the detail.

I simply want to copy into another spreadsheet these "Average" rows. But,
when I paste, it pastes the detail--not the "summarized" row averages.

Is there not a way of copying and pasting the summarized data?

childofthe1980s