Enable fill handle and cell drag-and-drop
| Registry value | fdisabledman_36_1 |
| Group Policy | Enable fill handle and cell drag-and-drop |
| German version | Ausfüllkästchen und Drag & Drop von Zellen aktivieren |
| Intune settings catalog | Enable fill handle and cell drag-and-drop (User) |
| Scope | User · HKCU |
| ADMX | excel16.admx · L_EnableFillHandleAndCellDragAndDrop |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\excel\options\binaryoptions | |
| fdisabledman_36_1 | Enabled = 0 · Disabled = 1 |
Not configured = the value does not exist – the application default applies and users may change the setting.
PowerShell
Check the current value (read-only)
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
$key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions"
foreach ($name in @('fdisabledman_36_1')) {
try { '{0} = {1}' -f $name, (Get-ItemPropertyValue -Path $key -Name $name -ErrorAction Stop) }
catch { '{0}: not configured' -f $name }
}Admin rights needed: HKCU\Software\Policies is read-only for standard users. An elevated session writes to the admin's own HKCU – to set it for another signed-in user, change $root to Registry::HKEY_USERS\<SID>.
Enable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'fdisabledman_36_1' -PropertyType DWord -Value 0 -Force -ErrorAction Stop | Out-Null # Enabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Disable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'fdisabledman_36_1' -PropertyType DWord -Value 1 -Force -ErrorAction Stop | Out-Null # Disabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Reset to Not configured
# --- Settings --- $root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>' $key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions" Remove-ItemProperty -Path $key -Name 'fdisabledman_36_1' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Enable fill handle and cell drag-and-drop (User)
Settings catalog → Add settings → search for the name above.
Intune Settings Catalog Viewer ↗
Alternative: custom profile (OMA-URI)
| OMA-URI | ./User/Vendor/MSFT/Policy/Config/excel16v2~Policy~L_MicrosoftOfficeExcel~L_ExcelOptions~L_Advanced/L_EnableFillHandleAndCellDragAndDrop |
| Data type | String |
| Value | <enabled/> · <disabled/> |
Cloud Policy
Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Enable fill handle and cell drag-and-drop. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.
Microsoft 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.
Same category: Microsoft Excel 2016 › Excel Options › Advanced
- Number of folders in the Recent Folders listmax display
- Default sheet directiondefaultsheetr2l
- Cursor movementcursorvisual
- Show control characterscontrolcharacters
- Microsoft Excel menu or Help keymenukey
- Transition navigation keysfisi_33_1
- Ignore other applicationsfddeenabled_6_1
- Zoom on roll with IntelliMousefrollzoom_98_1
- Show namesfshowchartnames_96_1
- Show valuesfshowcharttipvalues_97_1
- Edit directly in cellfnoincell_66_1
- Alert before overwriting cellsfnodragwarning_76_1
All policies in this category · All 173 policies of excel16.admx