Default Sheets
Explanation
Specifies the initial number of worksheets to create in a new workbook.
Registry
HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options- Value name
- not defined in the ADMX
Enable / disable values: not defined in the ADMX (see the options below).
PowerShell
PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.
Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.
Enable
# Enable: excel16/L_DefaultSheets
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Sheets in new workbook
Set-ItemProperty -Path $k -Name 'defsheets' -Value 3 -Type DWord # between 1 and 255Disable
# Disable: excel16/L_DefaultSheets
# No value is written in the "Disabled" state (nothing defined in the ADMX)Revert to "Not configured"
# Revert to "Not configured": excel16/L_DefaultSheets
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
Remove-ItemProperty -Path $k -Name 'defsheets' -ErrorAction SilentlyContinueOptions (1)
| Label | Control | Registry value | REG type | Constraints / details |
|---|---|---|---|---|
| Sheets in new workbookL_Sheetsinnewworkbook | Numeric boxdecimal | defsheets | REG_DWORD | Min: 1 · Max: 255 · Default (UI): 3 |
Application
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.