Policy

Enable fill handle and cell drag-and-drop

This policy setting sets the "Enable fill handle and cell drag-and-drop" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will enable the fill handle and allow drag-and-drop. This is the default behavior. If you disable this policy setting, Excel will disable the fill handle and drag-and-drop will not be allowed.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Excel Options / Advanced
Policy ID b8ef86a3df96
Internal name L_EnableFillHandleAndCellDragAndDrop

Registry

Copy registry mappings

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

Policy notes

This policy setting sets the "Enable fill handle and cell drag-and-drop" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will enable the fill handle and allow drag-and-drop. This is the default behavior. If you disable this policy setting, Excel will disable the fill handle and drag-and-drop will not be allowed.

Related policies

Alert before overwriting cellsAllow formatting and labels to track data pointsAlternate startup file locationAsk to update automatic linksAutomatically Flash FillAutomatically insert a decimal pointComments