单元格覆盖_关闭覆盖单元格警告

单元格覆盖

关闭覆盖单元格警告 (Turn Off the Overwriting Cell Warning)

Several times every day, I drag something from one part of a worksheet to another. If there's already something in that destination cell, Excel shows a message that asks me if I'm sure I want to do this.

每天有几次，我将某些东西从工作表的一部分拖到另一部分。 如果该目标单元格中​​已经有东西，Excel会显示一条消息，询问我是否确定要这样做。

确认讯息 (Confirmation Message)

Here's the message that Excel shows: Do you want to replace the contents of the destination cells?

这是Excel显示的消息：是否要替换目标单元格的内容？

About 99.99% of the time, yes, I really want to replace the contents of that cell. So, I click OK, and the data moves.

大约99.99％的时间，是的，我真的很想替换该单元格中的内容。 因此，我单击确定，然后数据移动。

That other 0.01% of the time, when I accidentally drag onto the wrong cell, I'd probably notice the mistake without Excel helping me, and just hit the Undo button.

在其他0.01％的时间内，当我不小心将光标拖到错误的单元格上时，如果没有Excel的帮助，我可能会注意到该错误，只需单击“撤消”按钮即可。

The result of Excel's help is that it slows me down, for no reason.

Excel的帮助结果是无缘无故地拖慢了我的脚步。

关闭讯息 (Turn the Message Off)

Finally, after all these years of using Excel, I noticed that there's a way to turn this feature off. (I prefer to think of this as the result of focused vision, not a lack of observation.)

最终，在使用Excel多年之后，我注意到有一种方法可以关闭此功能。 (我更喜欢将其视为集中注意力的结果，而不是缺乏观察力。)

Just in case you hadn't notice this setting either, here's how you can get rid of that message.

以防万一您也没有注意到此设置，这是摆脱该消息的方法。

要关闭Excel 2007中的功能，请执行以下操作： (To turn off the feature in Excel 2007:)

1. At the top left of the Ribbon, click the Office button
   在功能区的左上方，单击“ Office”按钮
2. Click the Excel Options button
   单击Excel选项按钮
3. Click Advanced
   点击高级
4. Remove the check mark from Alert before overwriting cells, then click OK
   在覆盖单元格之前，从“警报”中删除复选标记，然后单击“确定”。

要关闭Excel 2003中的功能，请执行以下操作： (To turn off the feature in Excel 2003:)

1. Click the Tools menu, then click Options
   单击工具菜单，然后单击选项
2. Click Edit tab
   单击编辑选项卡
3. Remove the check mark from Alert before overwriting cells, then click OK
   在覆盖单元格之前，从“警报”中删除复选标记，然后单击“确定”。

翻译自: https://contexturesblog.com/archives/2009/02/16/turn-off-the-overwriting-cell-warning/

单元格覆盖