Policy
Automatically Flash Fill
This policy setting controls the "Automatically Flash Fill" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will enable automatic Flash Fill. This is the default behavior. If you disable this policy setting, Excel will turn off the Automatic Flash Fill feature.
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Excel Options / Advanced
Policy ID
debf8abd5228Internal name
L_AutomaticallyFlashFillRegistry
Copy registry mappings
HKCU\software\policies\microsoft\office\16.0\excel\options\flashfill (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\excel\options\flashfill (disabled) = 0Policy notes
This policy setting controls the "Automatically Flash Fill" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will enable automatic Flash Fill. This is the default behavior. If you disable this policy setting, Excel will turn off the Automatic Flash Fill feature.
Related policies
Alert before overwriting cellsAllow formatting and labels to track data pointsAlternate startup file locationAsk to update automatic linksAutomatically insert a decimal pointCommentsCursor movementCut and copy objects with cellsDefault sheet directionEdit directly in cellEnable AutoComplete for cell valuesEnable automatic percent entryEnable fill handle and cell drag-and-dropExtend data range formats and formulasForce support for Unicode surrogates in Excel 2021 and Excel 2024Function tooltipsIgnore other applicationsMicrosoft Excel menu or Help keyMove selection after EnterMove selection after Enter direction