Policy

Alert before overwriting cells

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.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Excel Options / Advanced
Policy ID 36ecda4a332f
Internal name L_Alertbeforeoverwritingcells

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnodragwarning_76_1 (enabled) = 0
HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnodragwarning_76_1 (disabled) = 1

Policy notes

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.

Related policies

Allow formatting and labels to track data pointsAlternate startup file locationAsk to update automatic linksAutomatically Flash FillAutomatically insert a decimal pointCommentsCursor movement