How do I suppress the "Do you want to overwrite the destination cells" message

R

Rojo Habe

By default when you move cells to a location already containing data, Excel
will ask if you want to overwrite the contents of the destination cells. In
Excel 2000 I had the option to turn this message off and it would
automatically overwrite without asking (I could always use Undo if I made a
mistake). I can't find anywhere to do this in Excel 2007 and searching for
"automatically overwrite destination cells without asking" has come up with
nothing, either in the Help files or online.

Where have they hidden it or have they removed it altogether?
 
R

Rojo Habe

Ah! Now I feel stupid.

Just had another look and found it in seconds!

Sorry to waste your bandwidth.
 

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

Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Save a copy or Overwrite changes popup message 1
Suppressing "Do you want to save" message when closing the slideshow 0
Do you want to replace the destination cells? 5
Prevent PivotTable Overwrite Warning and Disallow Overwrite 0
Excel SaveAs to force overwrite of extant file 1
Do you want to replace the contents of 1
excel 2007 - copying cells with conditional formating 2

Top