Formatting Issues

How to Fix Excel Table Not Extending Formatting to a New Column

Nimra Malik Oct 20, 2026 868 views

Question details

The user needs their Excel table to automatically apply its formatting and formulas to newly added adjacent columns.

Fix Excel Table Not Extending Formatting to a New Column

Product: Microsoft Excel
Device & OS: not provided
Scenario: Adding a new heading or entering data immediately to the right of an existing formatted Excel table.
Observed behavior: The newly added column does not inherit the existing table formatting or the calculated-column formulas automatically.

Before you start

Ensure that your data is formatted as an actual Excel Table (using the Insert > Table feature) and not just a regular range with manual cell borders and background colors.

Solution 1Recommended

Enable AutoFormat As You Type for Tables

Adjust Excel's AutoCorrect settings to allow tables to automatically expand when new rows or columns are added.

Excel relies on specific AutoCorrect options to determine whether it should automatically extend formatting and formulas. If these options are disabled, the table boundary will not expand to include adjacent data entries.

Access Excel Options

Open your Excel workbook, click on 'File' in the top-left corner, and select 'Options' at the bottom of the menu.

Navigate to Proofing Settings

In the Excel Options dialog box, select 'Proofing' from the left-hand pane.

Open AutoCorrect Options

Click the 'AutoCorrect Options...' button located in the AutoCorrect options section.

Enable Table Expansion

Switch to the 'AutoFormat As You Type' tab. Check the box for 'Include new rows and columns in table'.

Enable Formula Filling

In the same tab, check the box for 'Fill formulas in tables to create calculated columns' to ensure your formulas also copy over automatically.

Save and Test

Click 'OK' on both dialog boxes to apply the settings. Type a new header directly adjacent to your table to verify that the formatting extends automatically.

Enable AutoFormat As You Type for Tables

Tip: Once enabled, typing data directly below or adjacent to a table will seamlessly integrate the new data into the table's structure without requiring manual resizing.

Solution 2

Manually Resize the Table Range

If automatic expansion is disabled or you prefer manual control, you can drag the table boundary to include the new column.

Seamless Table Management

Easily Manage and Expand Tables with WPS Office

WPS Spreadsheet handles table formatting intuitively. You can easily format ranges as tables and have them automatically expand to include new columns or rows, ensuring your formulas and styles stay perfectly aligned without digging through complicated settings.

1. Open Your Data in WPS Spreadsheet: Launch WPS Office, open your spreadsheet, and select the range of data you want to format.
2. Format as Table: Navigate to the 'Home' tab, click 'Format as Table', and choose your preferred visual style from the gallery.
3. Confirm Headers: Ensure the 'My table has headers' option is checked if your data includes titles, then click 'OK'.
4. Expand Automatically: Simply type a new header in the cell next to the last table column, and WPS Spreadsheet will instantly expand the table formatting to include it.

Automatically extend table formatting to new rows and columns by defaultHighly compatible with Microsoft Excel (.xlsx) file formatsLightweight, fast, and completely free to useIntuitive user interface for effortless data management

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel table suddenly stop expanding automatically?

This usually happens if the 'Include new rows and columns in table' setting was accidentally disabled, or if you previously clicked the AutoCorrect Options smart tag that appears near a newly added row/column and selected 'Stop Automatically Expanding Tables'.

Can I apply formulas to an entire column without using a formatted table?

Yes, you can manually copy and paste the formula down the column, or double-click the small fill handle at the bottom-right of the cell containing the formula. However, using a formatted Table automates this process for future data entries.

Does formatting as a table affect my existing data or formulas?

No. Formatting as a table applies visual styles (like banded rows) and enables advanced features (like automatic filtering and formula filling), but it does not change the actual values or underlying data in your cells.

How do I stop Excel from automatically filling formulas in tables?

If you want to disable this feature, go to File > Options > Proofing > AutoCorrect Options. Select the 'AutoFormat As You Type' tab, and uncheck 'Fill formulas in tables to create calculated columns'.

Document & File Issues