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 Hive | HKEY_CURRENT_USER |
Registry Path | software\policies\microsoft\office\16.0\excel\options |
Value Name | autoexpandlistrange |
Value Type | REG_DWORD |
Enabled Value | 1 |
Disabled Value | 0 |