In Excel, how do you copy and paste just the subtotals into anoth.

When I have a spreadsheet with subtotals, sometimes I just want to copy the
subtotals into another sheet and forget about what is being summed to give me
the subtotal. How do I copy and paste only the subtotals.

Hi

if you're talking about the situation where if rows are hidden (through the
data / subtotals function) when you select just the subtotals and copy &
paste them onto another sheet all the hidden rows come too, if so:

collapse the outline so only the subtotals are visible
select the area containing the subtotals and then choose
edit / goto and click the special button
choose visible cells only and click OK
now copy & paste as normal

Cheers
JulieD

"mmiazga" <[email protected]> wrote in message
news:[email protected]...
> When I have a spreadsheet with subtotals, sometimes I just want to copy
> the
> subtotals into another sheet and forget about what is being summed to give
> me
> the subtotal. How do I copy and paste only the subtotals.

Shrink the range with the minus buttons so you only see the subtotals, select
the range, press F5 and select visible cells only, copy and paste


Regards,

Peo Sjoblom

"mmiazga" wrote:

> When I have a spreadsheet with subtotals, sometimes I just want to copy the
> subtotals into another sheet and forget about what is being summed to give me
> the subtotal. How do I copy and paste only the subtotals.

Hi

This works well - but
when you subtotal excel inserts the word 'total' on the same line - as
in theis example 'company name'

How can I remove the word total?

In my case I am subtotaling by invoice number - after I subtotal it
states '123456 total' - 123456 = invoice number

When I do the special copy/paste below the '123456 total' is pasted on
a new line - but I cannot have the word total there - becuase I need
to upload the invoice number as format number into another program

How can I get rid of the word total?

Thanks


On Wed, 19 Jan 2005 23:57:54 +0800, "JulieD"
<[email protected]> wrote:

>Hi
>
>if you're talking about the situation where if rows are hidden (through the
>data / subtotals function) when you select just the subtotals and copy &
>paste them onto another sheet all the hidden rows come too, if so:
>
>collapse the outline so only the subtotals are visible
>select the area containing the subtotals and then choose
>edit / goto and click the special button
>choose visible cells only and click OK
>now copy & paste as normal
>
>Cheers
>JulieD
>
>"mmiazga" <[email protected]> wrote in message
>news:[email protected]...
>> When I have a spreadsheet with subtotals, sometimes I just want to copy
>> the
>> subtotals into another sheet and forget about what is being summed to give
>> me
>> the subtotal. How do I copy and paste only the subtotals.
>

Hi

as you're already copying and pasting onto the next row - to remove the word
total i would just use
edit / replace
in the find box type
total
(with a space in front of it)
and in the replace box don't type anything
now do a "replace all" and see if this gives you what you want.

Cheers
JulieD


"yahoo" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> This works well - but
> when you subtotal excel inserts the word 'total' on the same line - as
> in theis example 'company name'
>
> How can I remove the word total?
>
> In my case I am subtotaling by invoice number - after I subtotal it
> states '123456 total' - 123456 = invoice number
>
> When I do the special copy/paste below the '123456 total' is pasted on
> a new line - but I cannot have the word total there - becuase I need
> to upload the invoice number as format number into another program
>
> How can I get rid of the word total?
>
> Thanks
>
>
> On Wed, 19 Jan 2005 23:57:54 +0800, "JulieD"
> <[email protected]> wrote:
>
>>Hi
>>
>>if you're talking about the situation where if rows are hidden (through
>>the
>>data / subtotals function) when you select just the subtotals and copy &
>>paste them onto another sheet all the hidden rows come too, if so:
>>
>>collapse the outline so only the subtotals are visible
>>select the area containing the subtotals and then choose
>>edit / goto and click the special button
>>choose visible cells only and click OK
>>now copy & paste as normal
>>
>>Cheers
>>JulieD
>>
>>"mmiazga" <[email protected]> wrote in message
>>news:[email protected]...
>>> When I have a spreadsheet with subtotals, sometimes I just want to copy
>>> the
>>> subtotals into another sheet and forget about what is being summed to
>>> give
>>> me
>>> the subtotal. How do I copy and paste only the subtotals.
>>
>