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" 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" wrote in message
...
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?