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
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Excel Options / Advanced
Policy IDdebf8abd5228
Internal nameL_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