Enable fill handle and cell drag-and-drop
Explanation
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.
Registry
HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions- Value name
fdisabledman_36_1
| State | Value written |
|---|---|
| Enabled | REG_DWORD = 0 |
| Disabled | REG_DWORD = 1 |
PowerShell
PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.
Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.
Enable
# Enable: excel16/L_EnableFillHandleAndCellDragAndDrop
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'fdisabledman_36_1' -Value 0 -Type DWordDisable
# Disable: excel16/L_EnableFillHandleAndCellDragAndDrop
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'fdisabledman_36_1' -Value 1 -Type DWordRevert to "Not configured"
# Revert to "Not configured": excel16/L_EnableFillHandleAndCellDragAndDrop
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions'
Remove-ItemProperty -Path $k -Name 'fdisabledman_36_1' -ErrorAction SilentlyContinueApplication
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.