Policy

Extend data range formats and formulas

This policy setting sets the "Extend data range formats and formulas" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will allow the user to automatically format new items added to the end of a list to match the format of the rest of the list. This is the default behavior. If you disable this policy setting, Excel will not automatically format new items added to the end of a list.

Policy
Pack Microsoft Office
Category Microsoft Excel 2016 / Excel Options / Advanced
Policy ID 5e0d642b8760
Internal name L_ExtendDataRangeFormatsAndFormulas

Registry

Copy registry mappings

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

Policy notes

This policy setting sets the "Extend data range formats and formulas" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will allow the user to automatically format new items added to the end of a list to match the format of the rest of the list. This is the default behavior. If you disable this policy setting, Excel will not automatically format new items added to the end of a list.

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