Copy Sub Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I have a worksheet with subtotals. ( I used data - subtotals to
create the subtotals) I copied the subtotals to a new worksheet everything
else is copied. All I need is the subtotals only thanks
 
Do you just want the values, not the formulas behind them? Then just select
Edit--Paste special--values.
 
Dave F I had tried that. Let me clarify...the subtotals are grouped on
the left of the worksheet there is an + . When I copy to a new worksheet it
is still grouped all I want is the totals
 
Hide the details
Select the range to copy
Edit|Goto|Special|Visible cells only
Edit|Copy

and then off to the new location
edit|paste
 
Dave Super! thank sooo much

Dave Peterson said:
Hide the details
Select the range to copy
Edit|Goto|Special|Visible cells only
Edit|Copy

and then off to the new location
edit|paste
Click to expand...
 
Back
Top