Extend data range formats and formulas
- Policy ID
- L_ExtendDataRangeFormatsAndFormulas
- Scope
- User Configuration
- Supported on
- At least Windows Server 2008 R2 or Windows 7
- Source
- Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
- Category
- Microsoft Excel 2016 › Excel Options › Advanced
Description
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.
Registry
UserHKEY_CURRENT_USER
- extendlistREG_DWORD