Use calculated columns in an Excel table

Calculated columns in Excel tables are a powerful way to apply the same formula automatically to every row in a column. Here’s how you can use them:

How to create a calculated column in an Excel table:

1. Make sure your data is in an Excel Table
   (If not, select your range and press Ctrl + T to convert it.)
2. Add a new column header next to your existing table columns, or select an empty column inside the table.
3. Enter a formula in the first cell of the new column (right under the header).
   For example, if you want to multiply Quantity (in column B) by Price (in column C), you could enter:
   =[@Quantity] * [@Price]
4. Press Enter.
   Excel will automatically fill the formula down the entire column — this is your calculated column.

Key points:

• The formula uses structured references — [@ColumnName] means the value from the same row in that column.
• When you add new rows to the table, Excel automatically applies the formula in the calculated column for the new row.
• You can edit the formula in any cell of that column, and Excel will update the entire column formula accordingly.

Example: