View original (French)

"Do you want to replace the destination cell"

Solved
Rubiscube -  
 Rubiscube -
Hello,

In Excel 2010, I would like the message "Do you want to replace the contents of the destination cells" to stop appearing each time I move a cell over another.

Is it possible to do this without a macro or any other complex solution? I'm not an Excel geek...

Thank you for your help!

2 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Good evening,

    It's the same on 2003 as well.
    On 2003: 'tools/options/edit/alert before replacement'

    eric
    1
    1. Rubiscube
       
      Thank you!

      But I can't find that in Excel 2010, which, as you know, has completely restructured the menu (grrr...)

      Any ideas?

      Thanks in advance.
      0
    2. Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
       
      In 2010, you need to click on the Microsoft button in the top left corner and then you'll see Options in the bottom right corner.
      0
    3. Rubiscube
       
      I can find a "Options" menu in the "File" tab, but nothing in that menu regarding Excel alert management.

      And to be honest, I can't find a "Microsoft Orb" at the top left...

      Could you please tell me exactly where this orb is located? Thank you for your help!
      0
    4. Rubiscube
       
      Okay, I found it:

      File > Options > Advanced Options > Editing Options > Uncheck "Alert before replacement"

      Thanks everyone!
      0
  2. Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
     
    Hi, 

    I'm not an Excel geek...


    Well, these messages are precisely to avoid this kind of error, so why remove them?

    --
    Every problem has a solution... you just need to be persistent.
    0
    1. Rubiscube
       
      But if I make this type of move intentionally.

      And anyway, you can undo any mistake in Excel with a simple ctrl+z

      No, this message is completely unnecessary and annoying, and my good old Excel 2003 at work doesn’t impose it on me. How do I remove it from Excel 2010?
      0