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.

Supported on: At least Windows 7

Registry HiveHKEY_CURRENT_USER
Registry Pathsoftware\policies\microsoft\office\15.0\excel\options
Value Nameextendlist
Value TypeREG_DWORD
Enabled Value1
Disabled Value0

excel15.admx

Administrative Templates (Computers)

Administrative Templates (Users)