Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't copy Formula in Excel

Status
Not open for further replies.

jleboeuf

Programmer
May 2, 2001
50
0
0
CA
When i try to copy a formula , I only have the result in the cell. can someone tell me why ? Jean-Paul Leboeuf

jleboeuf@iquebec.com
 
Try this.....
go to the formula bar and select everything in it.
then press Ctrl+C (to copy)
Go to the cell you want to paste the formula in.
Go to the formula bar of that cell, and put your cursor in it.
Then press Ctrl+V(to paste it)
Or it you still have problems goto Edit, Paste Special, select Formula.
 
Have you been "Pasting Value" instead of the Formula?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top