Paste Special

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SallyGirl - 22 Aug 2006 04:27 GMT

I am trying to copy a series of cells within the same colum and paste within
that same colum without changing the formula....whenever I paste it changes
the formula to match the cells that I am pasting it in.
For example:
A4=sum(A1:A4)
I want to past this formula into A5 where it still reads (A1:A4)

I know that I am making this harder than it needs to be!
Please help

Reply to this Message

Peo Sjoblom - 22 Aug 2006 04:38 GMT

Are you using circular references or it is a typo? Normally you wouldn't
have =SUM(A1:A4) in cell A4 since you would get a circular reference error
and you need to change the iteration under tools>options>calculation.
Anyway, you can use absolute references like

=SUM($A$1:$A$3)

then copy and paste

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

>I am trying to copy a series of cells within the same colum and paste
>within
[quoted text clipped - 7 lines]
> I know that I am making this harder than it needs to be!
> Please help

Reply to this Message

Desert Piranha - 22 Aug 2006 04:44 GMT

SallyGirl Wrote:

> I am trying to copy a series of cells within the same colum and past
> within
[quoted text clipped - 7 lines]
> I know that I am making this harder than it needs to be!
> Please helpi Sally,

First this formula in cell A4 will give you a circular reference. Bu
to answer your question.

Make cell A4 active, then highlight and copy the formula from th
"Formula Bar", hit "Enter"
then go to the destination cell and paste normal. (Formul
Bar>copy>enter>paste

--
Desert Piranh

Reply to this Message