Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Sub Totals
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Sub Totals
Do you just want the values, not the formulas behind them? Then just select
Edit--Paste special--values. -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Wanna Learn" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Sub Totals
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 "Dave F" wrote: Do you just want the values, not the formulas behind them? Then just select Edit--Paste special--values. -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Wanna Learn" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Sub 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 Wanna Learn wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Sub Totals
Dave Super! thank sooo much
"Dave Peterson" wrote: 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 Wanna Learn wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
How do I copy Summary totals only from a subtotal list? | Excel Discussion (Misc queries) |