Didn't work ( moving formula/cell )

[Brenda]

Tried it again and not what I needed, sorry.
Let me reword this, in cell a1 say I have the formula b1+c1 and the
answer is 3. I want to copy this cell a1 to d1 and still have it say
b1+c1 and same answer 3.
Hope I have this worded correctly.
Thanks Again
Brenda

[Max]

Going by the underlying intent in your earlier post,
perhaps you didn't try what I suggested earlier ?: Try Cut > Paste
i.e. Cut out cell A1, paste into D1
(Don't Copy, use Cut)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Brenda" <Brenda391966@yahoo.com> wrote in message
news:i7u0o11bgrvl41m0dt3u2uik1cqihbq8ri@4ax.com...
> Tried it again and not what I needed, sorry.
> Let me reword this, in cell a1 say I have the formula b1+c1 and the
> answer is 3. I want to copy this cell a1 to d1 and still have it say
> b1+c1 and same answer 3.
> Hope I have this worded correctly.
> Thanks Again
> Brenda

[Brenda]

I tried that again on my range of formulas and I got a REF! error?
The cut part worked, but not the paste.

On Sun, 20 Nov 2005 21:42:11 +0800, "Max" <demechanik@yahoo.com>
wrote:

>Going by the underlying intent in your earlier post,
>perhaps you didn't try what I suggested earlier ?: Try Cut > Paste
>i.e. Cut out cell A1, paste into D1
>(Don't Copy, use Cut)
>--
>Rgds
>Max
>xl 97
>---
>Singapore, GMT+8
>xdemechanik
>http://savefile.com/projects/236895

[Jean Ruch]

"Brenda" <Brenda391966@yahoo.com> schrieb im Newsbeitrag
news:i7u0o11bgrvl41m0dt3u2uik1cqihbq8ri@4ax.com...
> Tried it again and not what I needed, sorry.
> Let me reword this, in cell a1 say I have the formula b1+c1 and the
> answer is 3. I want to copy this cell a1 to d1 and still have it say
> b1+c1 and same answer 3.
> Hope I have this worded correctly.
> Thanks Again
> Brenda

Hallo Brenda,

you could click on A1, put a quote before the equal sign. Now:
Enter / Copy / Paste in D1
And remove the quote signs both in A1 and D1.

regards

Jean

[Max]

Brenda,
Pl post more details of the formulae you have in A1:B3,
and where exactly are you pasting these.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Brenda" <Brenda391966@yahoo.com> wrote in message
news:1401o1hudk4rkq3d95hbh7g0frp6uemusr@4ax.com...
> I tried that again on my range of formulas and I got a REF! error?
> The cut part worked, but not the paste.

[Brenda]

I must be doing something wrong, gonna try again later. Thanks
Brenda

On Sun, 20 Nov 2005 22:06:51 +0800, "Max" <demechanik@yahoo.com>
wrote:

>Brenda,
>Pl post more details of the formulae you have in A1:B3,
>and where exactly are you pasting these.
>--
>Rgds
>Max
>xl 97
>---
>Singapore, GMT+8
>xdemechanik
>http://savefile.com/projects/236895

[Adam Kroger]

Use absolute addresses instead of relative?

=$B$1+$C$1

that way the cell references in the formula do not shift.

"Brenda" <Brenda391966@yahoo.com> wrote in message
news:i7u0o11bgrvl41m0dt3u2uik1cqihbq8ri@4ax.com...
> Tried it again and not what I needed, sorry.
> Let me reword this, in cell a1 say I have the formula b1+c1 and the
> answer is 3. I want to copy this cell a1 to d1 and still have it say
> b1+c1 and same answer 3.
> Hope I have this worded correctly.
> Thanks Again
> Brenda

[Brenda]

This worked along with all the others
Thanks to all
Brenda
On Sun, 20 Nov 2005 09:33:11 -0600, "Adam Kroger"
<adam_kroger<nospam>@hotmail.com> wrote:

>Use absolute addresses instead of relative?
>
>=$B$1+$C$1
>
>that way the cell references in the formula do not shift.
>
>"Brenda" <Brenda391966@yahoo.com> wrote in message
>news:i7u0o11bgrvl41m0dt3u2uik1cqihbq8ri@4ax.com...
>> Tried it again and not what I needed, sorry.
>> Let me reword this, in cell a1 say I have the formula b1+c1 and the
>> answer is 3. I want to copy this cell a1 to d1 and still have it say
>> b1+c1 and same answer 3.
>> Hope I have this worded correctly.
>> Thanks Again
>> Brenda
>