ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I suppress the "Do you want to overwrite the destination cells" message (https://www.excelbanter.com/setting-up-configuration-excel/238488-how-do-i-suppress-do-you-want-overwrite-destination-cells-message.html)

Rojo Habe

How do I suppress the "Do you want to overwrite the destination cells" message
 
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?


Rojo Habe

How do I suppress the "Do you want to overwrite the destination cells" message
 
Ah! Now I feel stupid.

Just had another look and found it in seconds!

Sorry to waste your bandwidth.


"Rojo Habe" wrote in message
...
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?




All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com