Alert before overwriting cells

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options\binaryoptions

Value name: fnodragwarning_76_1

Enabled: fnodragwarning_76_1 = 0

Disabled: fnodragwarning_76_1 = 1

Description

This policy setting sets the "Alert before overwriting cells" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will give a warning if cells are about to be overwritten. This is the default behavior. If you disable this policy setting, Excel will suppress the warning that cells are about to be overwritten.