Excel Table Formulas Not Carrying Down? Fixes That Work

Formulas & functions · Updated November 19, 2026

If a formula in an Excel table is not carrying down, first confirm the data is an actual table, then check that Excel’s calculated-column setting is enabled. In Microsoft 365 for Windows, go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type and select Fill formulas in tables to create calculated columns; then enter the formula in a table cell again.

How table formulas are supposed to fill

An Excel table is more than a formatted range. When you enter a formula in a table column, Excel can treat that column as a calculated column: it applies the same formula pattern to the other rows and to new rows added later. This is why a formula entered in one table row may appear throughout the column without dragging a fill handle.

For example, suppose a table has columns named Quantity, Unit Price, and Line Total. With those exact headers and a row containing 3 and 12.5, enter this in that row’s Line Total cell:

With the table columns named Quantity, Unit Price, and Line Total, and the current row containing Quantity 3 and Unit Price 12.5, use =[@Quantity]*[@[Unit Price]]. The result in that row is 37.5.

The references in square brackets are structured references. The @ means the value from the current row, so Excel can adjust the formula for each row while keeping the same formula pattern. This is usually more reliable than writing a formula against ordinary cell addresses when the data will grow or be sorted.

Confirm the range is really an Excel table

Colored banding, borders, or a bold header do not prove that data is a table. Click inside the range and look for the Table Design tab on the ribbon. If it appears, the selection is part of a table. If it does not, the range may only have formatting, so the calculated-column behavior will not apply.

To convert a range into a table, select a cell in the data and choose Insert > Table, check that the selected range is correct, and confirm whether the range has headers. You can also use Ctrl+T on Windows or Command+T on Mac. Check the header row carefully: duplicate, blank, or unexpectedly changed headings can make structured references confusing.

If only part of the data was included, click inside the table and use Table Design > Resize Table to extend it. A row directly beneath a table is not always part of that table. Entering a formula in a cell outside the table will not necessarily fill the existing table column, even if the cell looks like it belongs with the data.

Turn on the calculated-column option

Excel has an option that controls whether formulas are automatically filled into table columns. In Microsoft 365 for Windows, open File > Options > Proofing > AutoCorrect Options, select the AutoFormat As You Type tab, and enable Fill formulas in tables to create calculated columns. The setting can be switched off, which explains why a table may work on one computer but not another.

After turning it on, return to the table and enter the formula in a cell in the intended column. If Excel asks whether to overwrite formulas in the column, review the prompt: accepting applies the calculated-column formula consistently, while declining can leave a mixed column. If no prompt appears, inspect another row to see whether the formula was filled.

On Mac, Excel’s settings are under Excel > Settings or Preferences, depending on the release; look in AutoCorrect and its AutoFormat As You Type options for the table-formula setting. Labels and placement can vary between releases. Excel for the web supports tables, but the desktop AutoCorrect settings path is not available there. If the option cannot be found in the web app, check the workbook in desktop Excel.

Check for inconsistent formulas in the column

A calculated column is intended to use one formula pattern throughout. If some cells contain different formulas, values typed over formulas, or blank cells created by clearing only selected rows, Excel may treat the column as inconsistent rather than automatically replacing its contents. This can happen after pasting data from another workbook or editing individual rows.

Compare a working row with a row that did not fill. Click each formula cell and inspect the formula bar. If the references or calculation differ, decide which formula is correct, then enter that formula in the calculated column and accept Excel’s option to replace the column formulas if offered. Do not accept a replacement blindly if some rows intentionally use different logic.

For a straightforward calculated column, correcting the formula at the top or in a representative row often restores consistency. If the column contains values that must remain fixed, save a copy first and consider placing the formula in a separate column rather than overwriting those values.

Make sure new rows are inside the table

Formula propagation depends on adding data to the table, not merely typing below the last visible row. Click the last cell in the last table row and press Tab to create a new table row, or type into the first row immediately below the table and check whether Excel expands it. You can also extend the table using Table Design > Resize Table.

When a new row is part of the table, Excel normally carries a calculated-column formula into it if that column is consistent and the feature is enabled. Pasting an entire block over the table can behave differently: the pasted cells may replace formulas with values or blanks. After pasting, check the formula column and restore its formula if necessary.

Auto-expansion is separate from formula calculation. If typing below the table does not add a row, the entry may remain outside the table even though nearby formatting looks similar. Confirm the table boundary before troubleshooting the formula itself.

Distinguish a filling problem from a calculation problem

Sometimes the formula is present in every row but the displayed results do not change. That is a calculation issue, not a formula-fill issue. In Excel for Windows, check Formulas > Calculation Options and select Automatic if the workbook should recalculate as values change. Manual calculation can leave displayed results stale until recalculation occurs.

Another possibility is that Excel is displaying the formula as text instead of evaluating it. A cell formatted as Text before a formula is entered may show the formula characters. Select the affected cell, change its number format to General, then re-enter the formula. If the formula begins with an apostrophe, remove the apostrophe as well. Changing the format alone may not convert an existing text entry; re-entering it is the important step.

If the formula appears correctly but returns an error, filling may be working as designed. Check the formula’s column names, references, and input values. A column-name mismatch in a structured reference can cause an error, while a blank or text value in an input cell can produce an unexpected result depending on the formula.

Fill the formula manually when needed

If automatic propagation is unavailable or you need a one-time repair, enter the correct formula in the first intended table row and fill it through the relevant cells. Select the formula cell and the cells below it in that table column, then choose Home > Fill > Down. On Windows, Ctrl+D also fills down; on Mac, Control+D is the common Excel fill-down shortcut. Check several rows afterward to confirm that references adjusted as expected.

Dragging the fill handle is another option, but be careful to stop at the table’s last row and avoid overwriting existing data. For large tables, using the calculated-column setting is easier to maintain: when the table grows, new rows can inherit the formula automatically instead of requiring another manual fill.

Manual filling is not a fix for a range that is outside the table if the goal is future automatic propagation. First decide whether the formula should be in a table calculated column or in a conventional worksheet range, then use the corresponding approach.

Prevent the problem from returning

  • Keep one consistent formula pattern in each calculated column, and investigate any row that contains a different formula or a hard-coded value.
  • Add new records as table rows and verify that the table boundary includes them.
  • When importing or pasting data, avoid pasting over formula columns unless replacing those formulas is intentional.
  • Use clear, unique column headers so structured references remain easy to understand.
  • After changing a workbook’s layout, check both whether the formula filled and whether Excel recalculated its result.

These checks also clarify a common misconception: formatting a range to look like a table does not give it all table behaviors. Creating a real table is what enables structured references and calculated columns. Likewise, formula filling and automatic calculation are separate features; one can work while the other does not.

Frequently Asked Questions

Why does Excel fill a formula in one table but not another?

The tables may have different calculated-column consistency, or the workbook may be opened in an environment with different settings. Check that both ranges are actual tables, compare formulas in the column, and confirm the Fill formulas in tables to create calculated columns option in desktop Excel.

How do I make an Excel table formula apply to existing rows?

Enter the intended formula in a cell in that table column and accept the prompt to apply it to the calculated column, if Excel displays one. If it does not propagate, check the setting and inconsistent cells, or select the destination cells and use Home > Fill > Down.

Why does a formula not carry into a new row?

First confirm that the row is actually inside the table. Then check whether the formula column is consistent and automatic calculated-column filling is enabled. Typing below the table can create an ordinary worksheet row rather than a table row.

Will changing the formula in one row update the whole table?

Usually, Excel treats an edited formula as the calculated-column formula and offers to update the other cells. If the column already contains inconsistent formulas or values, it may not update every row automatically. Review the column before applying a replacement.

Why does the formula appear in the cell instead of a result?

The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the format to General and re-enter the formula. If formulas appear throughout the worksheet, check whether Show Formulas is enabled on the Formulas tab.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.