Why is Paste Formulas option is acting like Paste All option?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure if I'm doing something differently now, but I swore this used to
work.

1) Select cells with formulas
2) Copy
3) Select cells where I want these formulas
4) Paste Special - Formulas

Before: Formulas are now in the new cells.
Now: Formulas and Data overwrites the new cells.

Has anyone seen this or can anyone explain what I'm doing wrong?
Thanks,
jlk
 
Hi,

I am not sure if I misunderstood something but, if you hit ENTER after the
paste special comand, excel overwrith all information, fomarts, etc...

hth
regards from Brazil
Marcelo

"GoHokiesJLK" escreveu:
 
I appreciate the response, but I'm not pressing the Enter Key - I am clicking
the OK button...

jlk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Copy and Paste in Excel 2003 0
Excel 2007 Won't Paste Formulas 1
Paste Special Multiply Formulas not working in Excel 2007 1
Copying a formula but only getting the result 3
Why would a pasted formula not calculate the new cell refs? 2
Copy and Paste of Relative Cell References 1
Formulas displayed in cell rather than calculated values? 4
Formula results don't change when it's pasted/dragged into a new c 2

Back
Top