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.
PackMicrosoft Office
CategoryMicrosoft Excel 2016 / Excel Options / Advanced
Policy ID
c4fa513d208fInternal name
L_EnableAutoCompleteforcellvaluesRegistry
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) = 0Policy 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 pointCommentsCursor movementCut and copy objects with cellsDefault sheet directionEdit directly in cellEnable 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