Policy

Enable AutoComplete for cell values

This policy setting sets the "Enable AutoComplete for cell values" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will allow AutoComplete for cell values. This is the default behavior. If you disable this policy setting, Excel will turn off the AutoComplete feature.

Policy
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Excel Options / Advanced
Policy IDc4fa513d208f
Internal nameL_EnableAutoCompleteforcellvalues

Registry

Copy registry mappings

HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\fautocomplete_128_1 (enabled) = 1
HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions\fautocomplete_128_1 (disabled) = 0

Policy notes

This policy setting sets the "Enable AutoComplete for cell values" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will allow AutoComplete for cell values. This is the default behavior. If you disable this policy setting, Excel will turn off the AutoComplete feature.

Related policies

Alert before overwriting cellsAllow formatting and labels to track data pointsAlternate startup file locationAsk to update automatic linksAutomatically Flash FillAutomatically insert a decimal pointComments