Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
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 <atyahoo<dotcom ---- "Julie P." wrote in message ... 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! |
#3
![]() |
|||
|
|||
![]()
Highlight Right-click Copy Enter Right-click new location Paste
Vaya con Dios, Chuck, CABGx3 "Julie P." wrote in message ... 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! |
#4
![]() |
|||
|
|||
![]() "CLR" wrote in message ... 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 |
#5
![]() |
|||
|
|||
![]()
"Julie P." 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 <atyahoo<dotcom ---- |
#6
![]() |
|||
|
|||
![]()
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." wrote in message ... 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! |
#7
![]() |
|||
|
|||
![]()
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 wrote in message ... 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." wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
How to remove an extra line added by excel when pasting into notep | Excel Discussion (Misc queries) | |||
Copying and Pasting in dialog boxes | Excel Discussion (Misc queries) | |||
Copying & Pasting arrow help | Excel Discussion (Misc queries) | |||
Excel & Copying Formulas | Excel Worksheet Functions |