Automatically Flash Fill

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options

Value name: flashfill

Enabled: flashfill = 1

Disabled: flashfill = 0

Description

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.