Alert before overwriting cells: registry value fnodragwarning_76_1UserHKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions

Policy ID: L_Alertbeforeoverwritingcells
Scope: User Configuration
Supported on: At least Windows Server 2008 R2 or Windows 7
Source: Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
Category: Microsoft Excel 2016 › Excel Options › Advanced

Registry

fnodragwarning_76_1

REG_DWORDUser

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

Enabled value: 0
Disabled value: 1

Apply with .reg · CMD · PowerShell

.reg

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions]

; Options (use only one)
; Enabled
"fnodragwarning_76_1"=dword:00000000
; Disabled
"fnodragwarning_76_1"=dword:00000001

CMD

:: Options (use only one)

:: Enabled
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnodragwarning_76_1" /t REG_DWORD /d 0 /f
:: Disabled
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnodragwarning_76_1" /t REG_DWORD /d 1 /f

PowerShell

# Common: create the key
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Force | Out-Null

# Options (use only one)
# Enabled
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnodragwarning_76_1' -PropertyType DWord -Value 0 -Force | Out-Null
# Disabled
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnodragwarning_76_1' -PropertyType DWord -Value 1 -Force | Out-Null