Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy a formula?
Excel 2003 -WIN XP. I am trying to copy a formula from one cell to several.
My previous program (Office 97), worked just fine with the Lotus commands(/). I clicked on the cell to coppy, clicked Edit/Copy, it turned into a dotted line. I clicked on a cell to copy it to and clicked Edit/paste -- NOTHING!. I have done this several times. I even tried Paste Special. Am I missing something here? |
#2
|
|||
|
|||
Hi
have you tried the menu options as well (menu 'Edit - copy')? "Banjo" wrote: Excel 2003 -WIN XP. I am trying to copy a formula from one cell to several. My previous program (Office 97), worked just fine with the Lotus commands(/). I clicked on the cell to coppy, clicked Edit/Copy, it turned into a dotted line. I clicked on a cell to copy it to and clicked Edit/paste -- NOTHING!. I have done this several times. I even tried Paste Special. Am I missing something here? |
#3
|
|||
|
|||
Bonjour,
I think you can easely clik on the origin cell with your right button; you will see a small window on which you slect copy. Then clik with left button on destination cell and then click right button again the window, then select past. Normally it should work ... who knows!!! Rgds Walrus "Banjo" wrote: Excel 2003 -WIN XP. I am trying to copy a formula from one cell to several. My previous program (Office 97), worked just fine with the Lotus commands(/). I clicked on the cell to coppy, clicked Edit/Copy, it turned into a dotted line. I clicked on a cell to copy it to and clicked Edit/paste -- NOTHING!. I have done this several times. I even tried Paste Special. Am I missing something here? |
#4
|
|||
|
|||
Right clicking is the same as using the "Menu" Edit/Copy. It doesn't copy
anything. I do get the little box with the clipboard on it that pops up, with several choices. Makes no difference what I choose. Also i can't seem to get that box to go away. This is a new installation, am I missing something? Banjo "Banjo" wrote: Excel 2003 -WIN XP. I am trying to copy a formula from one cell to several. My previous program (Office 97), worked just fine with the Lotus commands(/). I clicked on the cell to coppy, clicked Edit/Copy, it turned into a dotted line. I clicked on a cell to copy it to and clicked Edit/paste -- NOTHING!. I have done this several times. I even tried Paste Special. Am I missing something here? |
#5
|
|||
|
|||
If pasting back into Excel, copy your cell as described previously then select Edit/Paste Special. From the options you can then select Formula. If you want to copy the formula outside of Excel, you must highlight the formula first (either from the formula bar or press F2) then select Copy either by right clicking or via the menu Edit/Copy. You should then be able to paste the formula to other applications. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=319027 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
How do I copy a formula in excel where part remains absolute the . | Excel Discussion (Misc queries) | |||
Copy Formula But Keep 1 Common Cell | Excel Discussion (Misc queries) | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
Copy formula to every 12th cell | Excel Worksheet Functions |