Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Banjo
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Walrus
 
Posts: n/a
Default

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   Report Post  
Banjo
 
Posts: n/a
Default

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   Report Post  
JimDandy
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When I copy down into the next cell the formula changes correctly. Jason30 Excel Discussion (Misc queries) 1 January 12th 05 11:55 PM
How do I copy a formula in excel where part remains absolute the . SRF Excel Discussion (Misc queries) 1 January 7th 05 01:41 PM
Copy Formula But Keep 1 Common Cell Towmech Excel Discussion (Misc queries) 3 December 18th 04 12:09 AM
Aligning Two Lists in Excel Rich Excel Discussion (Misc queries) 2 December 4th 04 05:44 PM
Copy formula to every 12th cell Jerry Derfler Excel Worksheet Functions 3 November 14th 04 11:09 PM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"