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.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Excel Options / Advanced
Policy ID debf8abd5228
Internal name L_AutomaticallyFlashFill

Registry

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) = 0

Policy 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 movement