Trouble copying and pasting a formula

[Julie P.]

This happens every time and really is annoying:

1) I try to copy a formula to another cell or to a Microsoft Word doc.

2) I go to the cell, and then highlight the formula in the data entry bar on
the top of the spreadsheet.

3) I then right-click to copy it.

4) I then click the Excel cell where I want to paste it.

5) This is when all hell breaks lose. The cell that I click in becomes part
of the current formula in the cell that I am copying from!! And there is no
way to stop it! Clicking more cells just makes this worse! I end up losing
my entire formula when I click "enter" to get out!!

This drives me crazy! Normally to get out of a cell, all I have to do is
click another cell.

How do I get out if this when it happens, and what is the proper way to copy
a formula?

Thanks so much!

[CLR]

Highlight > Right-click > Copy > Enter > Right-click new location > Paste

Vaya con Dios,
Chuck, CABGx3

"Julie P." <[email protected]> wrote in message
news:[email protected]...
> This happens every time and really is annoying:
>
> 1) I try to copy a formula to another cell or to a Microsoft Word doc.
>
> 2) I go to the cell, and then highlight the formula in the data entry bar
on
> the top of the spreadsheet.
>
> 3) I then right-click to copy it.
>
> 4) I then click the Excel cell where I want to paste it.
>
> 5) This is when all hell breaks lose. The cell that I click in becomes
part
> of the current formula in the cell that I am copying from!! And there is
no
> way to stop it! Clicking more cells just makes this worse! I end up losing
> my entire formula when I click "enter" to get out!!
>
> This drives me crazy! Normally to get out of a cell, all I have to do is
> click another cell.
>
> How do I get out if this when it happens, and what is the proper way to
copy
> a formula?
>
> Thanks so much!
>
>
>

[Max]

> 3) I then right-click to copy it.

After the above step, press Esc key (to exit edit mode)
before you proceed ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Julie P." <[email protected]> wrote in message
news:[email protected]...
> This happens every time and really is annoying:
>
> 1) I try to copy a formula to another cell or to a Microsoft Word doc.
>
> 2) I go to the cell, and then highlight the formula in the data entry bar
on
> the top of the spreadsheet.
>
> 3) I then right-click to copy it.
>
> 4) I then click the Excel cell where I want to paste it.
>
> 5) This is when all hell breaks lose. The cell that I click in becomes
part
> of the current formula in the cell that I am copying from!! And there is
no
> way to stop it! Clicking more cells just makes this worse! I end up losing
> my entire formula when I click "enter" to get out!!
>
> This drives me crazy! Normally to get out of a cell, all I have to do is
> click another cell.
>
> How do I get out if this when it happens, and what is the proper way to
copy
> a formula?
>
> Thanks so much!
>
>
>

[Julie P.]

"CLR" <[email protected]> wrote in message
news:[email protected]...
> Highlight > Right-click > Copy > Enter > Right-click new location > Paste
>
> Vaya con Dios,
> Chuck, CABGx3


Chcuk and Max: thanks so much to both of you!

Julie

[Max]

"Julie P." <[email protected]> wrote
> Chuck and Max: thanks so much to both of you!

You're welcome !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

[Wayman Bell]

I'll have to try this. I have been copying the formula, paste to word.doc,
esc, then copy from word.doc and paste into new cell.


"Julie P." <[email protected]> wrote in message
news:[email protected]...
> This happens every time and really is annoying:
>
> 1) I try to copy a formula to another cell or to a Microsoft Word doc.
>
> 2) I go to the cell, and then highlight the formula in the data entry bar
> on the top of the spreadsheet.
>
> 3) I then right-click to copy it.
>
> 4) I then click the Excel cell where I want to paste it.
>
> 5) This is when all hell breaks lose. The cell that I click in becomes
> part of the current formula in the cell that I am copying from!! And there
> is no way to stop it! Clicking more cells just makes this worse! I end up
> losing my entire formula when I click "enter" to get out!!
>
> This drives me crazy! Normally to get out of a cell, all I have to do is
> click another cell.
>
> How do I get out if this when it happens, and what is the proper way to
> copy a formula?
>
> Thanks so much!
>
>
>

[R.VENKATARAMAN]

you can try one more idea
more or less your earlier idea.

highlight the formula in the formula bar
copy(or control+c)
hit <Esc>------this is important and change in your idea
now pastes iit in another cell
it will take the same cells of the formula as if they are absolue references

do a few experiments.
=======================

Wayman Bell <[email protected]> wrote in message
news:[email protected]...
> I'll have to try this. I have been copying the formula, paste to word.doc,
> esc, then copy from word.doc and paste into new cell.
>
>
> "Julie P." <[email protected]> wrote in message
> news:[email protected]...
> > This happens every time and really is annoying:
> >
> > 1) I try to copy a formula to another cell or to a Microsoft Word doc.
> >
> > 2) I go to the cell, and then highlight the formula in the data entry
bar
> > on the top of the spreadsheet.
> >
> > 3) I then right-click to copy it.
> >
> > 4) I then click the Excel cell where I want to paste it.
> >
> > 5) This is when all hell breaks lose. The cell that I click in becomes
> > part of the current formula in the cell that I am copying from!! And
there
> > is no way to stop it! Clicking more cells just makes this worse! I end
up
> > losing my entire formula when I click "enter" to get out!!
> >
> > This drives me crazy! Normally to get out of a cell, all I have to do is
> > click another cell.
> >
> > How do I get out if this when it happens, and what is the proper way to
> > copy a formula?
> >
> > Thanks so much!
> >
> >
> >
>
>