Office Settings & Configuration

Fix an Excel Table That Does Not Expand When You Type

Kushani NimanthikaKushani Nimanthika Nov 22, 2026 868 views

Question details

The user needs an Excel table to expand when data is entered in an adjacent cell.

Fix an Excel Table That Does Not Expand When You Type
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the table

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.

2
Enable table expansion

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.

3
Test an adjacent entry

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.

4
Try a simple workbook

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.

Verify the table and enable automatic expansion
Check the table structure: A consistent layout can make a table easier to manage, but different data types alone do not necessarily prevent Excel from expanding it.
Free Microsoft Office alternative

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.

Work with spreadsheet tables in a familiar interfaceOpen and save Microsoft Excel XLSX filesUse a free, lightweight office suiteMove existing spreadsheets into WPS Spreadsheets
microsoft office alternative - wps office

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.