Copying Cells in List

I

infinite1013

If i have my cells sorted and subtotaled and close the brackets to show only
the subtotals, is there a way that I can copy only those subtotals without
copying all of the figures that make them up?
 
S

ScottFisher2004

Copy the subtoal cells. Go to where you want the values pasted. Then select
Edit from the menu bar, Paste Special from the drop-down, click 'values', and
select okay.
 
M

Mike H

Hi,

This should work.
Select the range with your subtotals in then

Edit|Goto|Special
Select Visible cells only
Click OK
Copy and paste as you require.

Mike
 
Top