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 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

the OK button...

jlk

1. I am unable to copy and paste and am unable to figure out why, wh.

2. Paste as JPEG format in Paste Special option of a word document

3. In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.

4. copy/paste with paste option box

5. how can i set default paste options so graphics paste as metafile

6. "paste special" only offers option to paste as "slide"

7. VBA replace paste command with Paste Special option

8. Changing the _default_ Paste options to paste cell contents only?

9. make in paste special "paste link" the default option.

10. the paste option is not available - keeps pasting repeatedly -

11. Paste Special, Formulas, is also pasting values. Why?

13. Paste Option button not working even after enabled in Options.

14. To copy and paste a formula or drag a formula now only pastes the.

15. Outlook acts like I am recurring meeting organizer even though I am NOT

3 post • Page:**1** of **1**