Fix an Excel Table That Does Not Expand When You Type
Question details
The user needs an Excel table to expand when data is entered in an adjacent cell.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user types a new row or column directly next to a formatted table.
- Observed behavior
- The table does not expand to include the new entry.
Identify the table’s current boundaries and check whether the new entry is immediately below the last table row or next to the last table column. Menu names and locations can vary by Excel version.
Verify the table and enable automatic expansion
Use this solution to confirm that the range is an Excel table and that automatic expansion is enabled.
Click inside the range and look for the Table Design tab on the ribbon. If it does not appear, select the range, choose Insert > Table, and confirm whether the range has headers.
In Excel for Windows, select File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type. Check Include new rows and columns in table, then select OK.
Type a value in the cell immediately below the table or a heading in the cell immediately to its right. Check whether the table border expands to include it.
Create a new workbook, enter column headings and a few rows, and select Insert > Table. Type in an adjacent cell to see whether expansion works there.

Resize the Excel table manually
Use this workaround when automatic expansion still does not include the new cells.
Edit spreadsheet tables with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheet tables. Its familiar interface and Excel format compatibility make it easy to move existing files into WPS Spreadsheets. It does not change Excel’s table expansion settings.

Frequently Asked Questions
How can I tell whether my range is an Excel table?
Click a cell in the range. If the Table Design tab appears on the ribbon, the cell is in an Excel table. Otherwise, select the range and choose Insert > Table.
Where is the automatic table expansion setting?
In Excel for Windows, go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and check Include new rows and columns in table.
Does a different data type stop an Excel table from expanding?
Not necessarily. Excel tables can contain different data types. Check that the entry is immediately adjacent to the table and that automatic expansion is enabled.
Can I add cells to a table without automatic expansion?
Yes. Click the table, select Table Design > Resize Table, and extend the range to include the new cells.




