Open in the explorer

Include new rows and columns in table

Type
User
GPO path
User Configuration › Policies › Administrative Templates › Microsoft Excel 2016 › Excel Options › Proofing › Autocorrect Options
Supported on
At least Windows Server 2008 R2 or Windows 7
ADMX file
excel16.admx
Internal name
excel16/L_Includenewrowsandcolumnsinlist

Explanation

When working in cells adjacent to a table (known as a "list" in previous versions of Excel), enabling this setting causes the adjacent row or column to become part of the table.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options
Value name
autoexpandlistrange
StateValue written
EnabledREG_DWORD = 1
DisabledREG_DWORD = 0

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_Includenewrowsandcolumnsinlist
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'autoexpandlistrange' -Value 1 -Type DWord

Disable

# Disable: excel16/L_Includenewrowsandcolumnsinlist
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'autoexpandlistrange' -Value 0 -Type DWord

Revert to "Not configured"

# Revert to "Not configured": excel16/L_Includenewrowsandcolumnsinlist
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
Remove-ItemProperty -Path $k -Name 'autoexpandlistrange' -ErrorAction SilentlyContinue

Application

Microsoft 365 Apps / Office (Microsoft) — November 2026 templates

Official templates downloaded on November 12, 2026.