how to copy and paste "averages"

C

childofthe1980s

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
 
S

Simon Lloyd

What said:
Hello

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

I click the "2", in order to collapse the rows to just show th
"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

childofthe1980
Click to expand...

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
E

Eduardo

Hi,
once you hit 2, highlight the range you get, then CTRL G, Special, Visible
cells only, copy, then paste it in your desire location

if this helps please click yes
 

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 just the summarized data 2
How to paste this down? 3
conditional formatting, filtering then copying to another sheet 0
Paste options button disappears 0
Dealing with a Pivot Table (when I don't want to) 0
Copy addition formula of non-consecutive horizontal cells 2
"collapsing" data--but only for certain rows 1
hidden rows, column copy-paste 0

Top