Include new rows and columns in table

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options

Value name: autoexpandlistrange

Enabled: autoexpandlistrange = 1

Disabled: autoexpandlistrange = 0

Description

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.