How do I copy a formula/paste w/o losing the cell content?

I have a formula such as "=sum(d34+d35)", I decided to move the location, but
when I move the location the formula is now "=sum(d31+d31). I would like to
move the first formula anywhere on the spreadsheet w/o it being changed. How
do you do that? Is it an absolute value or something like that?

Yes. The formula must be written as =sum($d$34+$d$35)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"CShannon" <CShannon@discussions.microsoft.com> wrote in message
news:04CAD401-FDF9-46C0-BCF4-D8F28A410ABE@microsoft.com...
> I have a formula such as "=sum(d34+d35)", I decided to move the location,
but
> when I move the location the formula is now "=sum(d31+d31). I would like
to
> move the first formula anywhere on the spreadsheet w/o it being changed.
How
> do you do that? Is it an absolute value or something like that?

OR,
Select the entire formula in the formula bar,
Right click and choose "COPY",
Hit <Enter>,
And paste anywhere you wish.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Anne Troy" <ng@officearticles.com> wrote in message
news:29ed$42bcc1ba$97c5108d$28773@allthenewsgroups.com...
> Yes. The formula must be written as =sum($d$34+$d$35)
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "CShannon" <CShannon@discussions.microsoft.com> wrote in message
> news:04CAD401-FDF9-46C0-BCF4-D8F28A410ABE@microsoft.com...
> > I have a formula such as "=sum(d34+d35)", I decided to move the
location,
> but
> > when I move the location the formula is now "=sum(d31+d31). I would
like
> to
> > move the first formula anywhere on the spreadsheet w/o it being changed.
> How
> > do you do that? Is it an absolute value or something like that?
>
>

Moving changes the formula unless you make the references absolute as Anne
suggests.

There is another way. Cut and paste instead of copy and paste, but that
removes the formula from its original cell.

--
Ken Russell

kenrussellyourhat@optushome.com.au
Remove yourhat to reply by e-mail
..

"CShannon" <CShannon@discussions.microsoft.com> wrote in message
news:04CAD401-FDF9-46C0-BCF4-D8F28A410ABE@microsoft.com...
>I have a formula such as "=sum(d34+d35)", I decided to move the location,
>but
> when I move the location the formula is now "=sum(d31+d31). I would like
> to
> move the first formula anywhere on the spreadsheet w/o it being changed.
> How
> do you do that? Is it an absolute value or something like that?

Point of information:

Strictly speaking your formula is incorrect, =D34+D35 would give you the
same answer. SUM() is intended for ranges eg =SUM(A1:A199). As mentioned
elsewhere if you want to copy this formula anywhere in the spreadsheet but
still sum the same values you must use absolute addresses.

"CShannon" wrote:

> I have a formula such as "=sum(d34+d35)", I decided to move the location, but
> when I move the location the formula is now "=sum(d31+d31). I would like to
> move the first formula anywhere on the spreadsheet w/o it being changed. How
> do you do that? Is it an absolute value or something like that?

If you really mean move, you can drag it across as well which doesn't update
it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RagDyer" <RagDyer@cutoutmsn.com> wrote in message
news:eHghcITeFHA.2664@TK2MSFTNGP15.phx.gbl...
> OR,
> Select the entire formula in the formula bar,
> Right click and choose "COPY",
> Hit <Enter>,
> And paste anywhere you wish.
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Anne Troy" <ng@officearticles.com> wrote in message
> news:29ed$42bcc1ba$97c5108d$28773@allthenewsgroups.com...
> > Yes. The formula must be written as =sum($d$34+$d$35)
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> > www.MyExpertsOnline.com
> >
> >
> > "CShannon" <CShannon@discussions.microsoft.com> wrote in message
> > news:04CAD401-FDF9-46C0-BCF4-D8F28A410ABE@microsoft.com...
> > > I have a formula such as "=sum(d34+d35)", I decided to move the
> location,
> > but
> > > when I move the location the formula is now "=sum(d31+d31). I would
> like
> > to
> > > move the first formula anywhere on the spreadsheet w/o it being
changed.
> > How
> > > do you do that? Is it an absolute value or something like that?
> >
> >
>

Or
=sum($d$34:$d$35)
or
=sum($d$34,$d$35)
or
=$d$34+$d$35

(I wouldn't use the + inside the =sum() function.)

But I bet your real point was about using absolute references.


Anne Troy wrote:
>
> Yes. The formula must be written as =sum($d$34+$d$35)
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
> "CShannon" <CShannon@discussions.microsoft.com> wrote in message
> news:04CAD401-FDF9-46C0-BCF4-D8F28A410ABE@microsoft.com...
> > I have a formula such as "=sum(d34+d35)", I decided to move the location,
> but
> > when I move the location the formula is now "=sum(d31+d31). I would like
> to
> > move the first formula anywhere on the spreadsheet w/o it being changed.
> How
> > do you do that? Is it an absolute value or something like that?

--

Dave Peterson