Enable fill handle and cell drag-and-drop

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

Registry

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

Value name: fdisabledman_36_1

Enabled: fdisabledman_36_1 = 0

Disabled: fdisabledman_36_1 = 1

Description

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.