Do you want to replace the destination cells?


M

Martin ©¿©¬

Hi
When copying and pasting in a spreadsheet I am getting the message
"Do you want to replace the destination cells"
I don't know why this message has started to appear, I must have hit
something.
Anyone know how to fix please?
 
Ad

Advertisements

G

Gary''s Student

Tools > Options > Edit > clear the alert before overwrighting cells checkbox.
 
M

Martin ©¿©¬

Tools > Options > Edit > clear the alert before overwrighting cells checkbox.

Thanks Gary
Took me a while to find it - using 2007
I have no idea what changed my settings !!
Only started happening this week
 
G

Gary''s Student

In 2007, click the fat button in the upper left of the screen. Then click
the Excel Options in the lower right. Then click Advanced. Then clear the
alert.
 
Ad

Advertisements

F

flerdle

I am using Excel2003 (SP3) on a PC and I have this problem. It's coming up
when using copy (or cut) and paste, NOT drag&drop. I've tried unchecking the
option related tod&d anyway (via tools/options/edit) but it happens either
way. From what I've read, it's NOT supposed to be giving a warning... ?

Interestingly, if I copy/cut one cell, it does not warn me. If i try two or
more, it has the warning box.

Anyone know how to fix in this version, or am I stuck with an incredibly
annoying "feature"?

flerdle
 
Ad

Advertisements


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

Top