Copy Sub Totals

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
 
G

Guest

Do you just want the values, not the formulas behind them? Then just select
Edit--Paste special--values.
 
G

Guest

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
 
D

Dave Peterson

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
 
G

Guest

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...
 

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

multiple subtotals in pivot table 1
Copying only subtotals 1
How do I copy a range in Excel without including hidden rows? 1
Copying subtotals 2
Sub Totals 5
Extremely sloooooooooow subtotalling 3
Subtotals in Excel 2007 1
Subtotals every "X" number of rows 3

Top